Sort Names entered as First Last to Last, First

A

Allison McWhirter

I have a list of names that the first then last names are entered in the same field. Is there a function that will allow me to resort this as Last, First. Even if there is a formula that will allow me to take the field that the names are in and create another field that shows Last, First...then I can sort on that new column.
 
K

Ken Wright

With a couple of blank columns to the right of your data - Select all the data
and do Data / text to columns / delimited / Space as delimiter / Hit OK

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



Allison McWhirter said:
I have a list of names that the first then last names are entered in the same
Click to expand...
field. Is there a function that will allow me to resort this as Last, First.
Even if there is a formula that will allow me to take the field that the names
are in and create another field that shows Last, First...then I can sort on that
new column.
 
J

jeff

Hi,

Use menu Data-> Test to Columns ; use space
as the delimiter.

jeff
-----Original Message-----
I have a list of names that the first then last names
Click to expand...
are entered in the same field. Is there a function that
will allow me to resort this as Last, First. Even if
there is a formula that will allow me to take the field
that the names are in and create another field that shows
Last, First...then I can sort on that new column.
 
Top