B
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)
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)