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