Split email address into seperat columns
 

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

Split email address into seperat columns
 

Just do a DataText To Columns with @ as the delimiter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mg_sv_r" wrote in message
...
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