Sort First and last name in single cell

R

rpielet

I have a mailing list of over 10,000 names, with the first name and las
name in a single cell. The first name is listed first. Is there a wa
to sort the column by last name or better yet isolate the last name t
a separate column so I can merge the data to a different application
Thank you in advance for your help. :
 
D

DDM

Rpielet, there's no way to sort by last name, given the way your data is
entered. Instead, use the Text to Columns command on the Data menu to put
first and last names in separate columns. It's very intuitive. Check it out.

Should you need to bring the first and last names together again, you can
easily concatenate them.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
D

Dennis

Use Data>>Text to Columns and use a space as the delimiter. If you use B1 as
target Column B will have first name and Col C will have last names. Copy
B1:C10000 and paste special values then sort.
Dennis
 
J

Jed

Assuming your first name and last name are separated by a space and your
first-last name is in cell A1, enter following formula :
Cell B1 =LEFT(A1,FIND(" ",A1))
Cell C1 =MID(A1,FIND(" ",A1)+1,LEN(A1))
and drag down formula to last cell in your list.
You should now have first name in Cell B1 and second name in Cell C1. Select
all names in Column B & Column C and copy and paste special ( values only)
in to another worksheet. You should now then be able to sort out by first or
last names. Hope this helps
Regards
Jed
 
Top