Thanks very much Kernow Girl, that is exactly what I want to do.
However I am a
bit of a novice at this. I have copied my column and replaced all the
@s with the formula you gave me, how do I now get the part after the
bracket of your formula to go into a seperate column so that I can sort
it (or am i doing this the wrong way round?)
Thanks

Kernow Girl wrote:
Hi Jammie - if you only want the .ac.uk part not @google.ac.uk this will do
it ---
just change the @ to .

MID(C3, SEARCH(".", C3) + 1, LEN(C3) - SEARCH(".",C3))

Yours - Dika

"Jammie" wrote:

Hi
I am trying to sort a column of email addresses by the end part of the
address eg john.smith @google.ac.uk the .ac.uk part.

Does anyone know an easy way to do this..?

Thanks