Covert text into rows

March 6, 2013 at 03:12:37
Specs: Windows 7
I have a whole lot of text where email addresses are seperated by semicolons, and I want to split it so each email address is on a seperate row? How do I do this?

See More: Covert text into rows

Report •

March 6, 2013 at 03:58:43
I assume that the email addresses are in one cell.

You should be able to start with the Text To Column feature. Choose "delimited" and use the semi-colon as your delimiter character. That should separate the emails addresses to columns.

Now select the email addresses and do a Copy...PasteSpecial...Transpose to change the columnized data into rows.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question