If the email address is before the symbol: Cell A1 includes email address
=left(a1,find("",a1,1)-1)

If the email address is after the symbol:
=right(a1,len(a1)-find("",a1,1))

Copy one of these formulas in a column and copy down your list.


"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