how i can aarange names in alphabetical odders

[ADNAN]

[Bob Phillips]

I assume you mean that you first and surnames in a cell and you want to sort
on surnames.

You will need to extract the surname into a separate helper column, using
MID and FIND functions (an example assuming names like John Smith,
=MID(A1,FIND(" ",A1)+1,99), and then sort both columns on the surname
column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ADNAN" <[email protected]> wrote in message
news:[email protected]...
>