Quick excel question

tres · 13 Nov 2008 at 10:19

I have a column of email address

I'm trying to remember how to seperate this into

[email protected] | name@ | domain.com

Any ideas?

Tomsk · 13 Nov 2008 at 10:42

A1 = email address
B1 = left(A1, find("@",A1)
C1 = right(A1, len(A1)-len(B1))

Nanobot · 13 Nov 2008 at 12:07

If its a fixed list, import the list into excel using the @ as a separator.
I'm guessing the list will update regularly so above expression is fine, I was just being quick and lazy.

tres · 13 Nov 2008 at 14:19

Both replies have helped hugely, thanks chaps!