Sort Names -- Names, Sort

F

Frank Kabel

Hi
try the following formula in a helper column (e.g. column
B):
B1.
=IF(ISNUMBER(FIND(",",A1)),TRIM(LEFT(A1,FIND(",",A1)-
1)),TRIM(MID(A1,FIND(" ",A1)+1,255)))

copy this formula for all rows and sort with this helper
column
-----Original Message-----
We have many worksheets of data. Some names are
Click to expand...
entered "First Last" in one cell, some are entered "Last,
First" in one cell. Once I've separated the two kinds of
names, how to I sort them based on the last name? We're
using Excel 2002. Thanks!
 
Top