thanks!
Jan
Phil Sharpe wrote:
> You could create a column using something like:
> MID(A1, SEARCH("@", A1) + 1, LEN(A1) - SEARCH("@", A1))
>
>
> "Jammie" <jan@in-equilibrium.co.uk> wrote in message
> news:1155553711.206899.185040@p79g2000cwp.googlegroups.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
> >