Sorting

U

ultra_xcyter

I have a list of names in a column that are listed first name first an
then last name (ex. John Doe). I want to sort this list by last name
but I don't want to have to manually go back and retype each name b
last name first and first name (ex. Doe, John).

Is there a way to sort the names by last name without retyping all th
names?
 
J

JulieD

Hi

you can use data / text to columns to split them into two columns and then
you can sort on last name ...
ensure that there is a blank column to the right of the names
select the list of names
choose data / text to columns
ensure delimited is selected - next
untick tab, tick space
click finish

Cheers
JulieD
 
C

CLR

One way is, you can separate the first and last names into two columns
using Data > Text to columns, and using the comma as a
delimiter.........then easily sort on the LastName column as the first Key.
Just be sure to insert a couple empty columns to the right of your Name
column before you start, and for sure, just work from a COPY of your file.

Vaya con Dios,
Chuck, CABGx3
 
Top