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