separate values from 1 cell to many rows
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
|