Split email address into seperat columns

M

mg_sv_r

Hi,

Don't know if this is possible but hopefully someone here can tell me.

I have a worksheet, hundreds of rows long. One column contains email
addresses. Is it possible to split the email addresses so the everything
before the '@' appears in one column and everything after the '@' appears in
another.

I need to be able to sort these records by email domain and this is proving
very difficult.

Thank you in advance for any help. It really is much appreciated.

John
 
B

Bob Phillips

Just do a Data>Text To Columns with @ as the delimiter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top