Sort Names entered as First Last to Last, First

[Guest]

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.

 

[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
----------------------------------------------------------------------------

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.

 

[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

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.