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]...
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks