Sort from a certain point in a cell?

[k1rkyc]

Hi all,

Just looking for some advice and this looked like a good place!

I have a spreadsheet full of email addresses and wanted to sort by the address, but only from the address after the @ symbol.

Does anyone know if this can be done? Hope you know what I mean

Thanks in advance,
Kirsten

[MickeyGreen]

I'd suggest adding another column to extract the text you want to sort by.

Assuming the addresses are in column A, use the following:

=RIGHT(A1,LEN(A1)-SEARCH("@",A1))

[daddylonglegs]

You could use a formula to extract the portion of the email address after the @

e.g. if A1 contains

[email protected]

use this formula in B1 to get just domain.com

=REPLACE(A1,1,FIND("@",A1),"")

copy formula down column, then sort by column B

[k1rkyc]

Hi Mickey and daddy,

Thanks for the fast replies :-) this works, however, I'm then left with a column of aol.com or tiscali.co.uk which means I can't sort the whole email addresses.

Anything else I can do?

Thanks v much

[MickeyGreen]

I'm not sure what you are asking then. Can you give us an example?

[daddylonglegs]

Once you have the formula filled in column B select both columns A and B and sort by column B

Column A will now contain your email addresses as before but now sorted by whatever comes after the @

[k1rkyc]

Ah of course!! Thank you so much for your help guys, MUCH appreciated! :-)