Do you have MSWord?

If yes, copy that list into a new document in MSWord.
While in MSWord
Hit ctrl-a to select all the text
hit ctrl-h (edit|Replace in Word2003 menus)
Find what: (the greater than symbol)

Select the replace with box
Hit More
choose Special
Choose Paragraph mark
Then replace all.

Now select that list and copy|paste into excel.
(or edit|paste special|text in excel if you don't want the formatting.)




bj 3233 wrote:

I have a list of email address that are separated by the symbol.
I want to separte each address to its own row

--

Dave Peterson