Select the cell and EditReplace

What:

With: CTRL + j

Replace all.

With cell still selected hit F2 then select all text in the formula bar and
Copy.

Select enough cells below to hold all the addresses then EditPaste.

Ignore the warning about "not same size" and hit OK

Your addresses are now in individual cells in the column.


Gord Dibben MS Excel MVP

On Sun, 7 Feb 2010 09:25:01 -0800, 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