Tuesday, January 3, 2012

A Quick Method to Parse Text in Excel

I needed to parse out the domain name from a list of email addresses. I simply used Excel's Text to Columns with the @ as the delimiter. But of course!

In Excel: Data > Text to columns > Delimited > Other: @

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...