Thread: Sort a column of email addresses by end portion of address
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jammie Jammie is offline
external usenet poster
  
Posts: 4
Default Sort a column of email addresses by end portion of address
thanks!
Jan
Phil Sharpe wrote:
You could create a column using something like:
MID(A1, SEARCH("@", A1) + 1, LEN(A1) - SEARCH("@", A1))


"Jammie" wrote in message
oups.com...
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


Reply With QuoteReply With Quote