Alphabetical Lists

C

CW

I recieved a list that contains names listed first name then last name in the
same cell. Is there a way to either sort last name first or to convert this
to separate the cells?
 
B

Bondi

CW said:
I recieved a list that contains names listed first name then last name in the
same cell. Is there a way to either sort last name first or to convert this
to separate the cells?
Click to expand...

Hi CW,

You can split up the names in to two or more cells if you highlight
your list. Then go to Data -> Text To Colums here Chose Delimited and
press next. Chose the delimier your list is using (Might be Space) and
press finish. All the names should be split into diffrent cells.

Regards,
Bondi
 
T

tim m

Try this,
highlight your cells and the go 'Data'...'text to
columns'....'delimited'...put the check mark in the 'space' box and click
'Next' and then 'finish'

This should seperate the 1st and last names into 2 columns and you can sort
via the last name. (This is assuming you have a space between the 1st and
last names in the original cell.)

If you then want to put the names back together in one cell you used the
CONCATENATE function.
 
G

Gord Dibben

CW

To split into two cells...................

It may as simple as Data>Text to Columns>De-limited by>Space.

Then again, if you have cells with more than just two names or a middle initial,
you may require something else.

I would recommend Chip Pearson's site.

http://www.cpearson.com/excel/FirstLast.htm


Gord Dibben MS Excel MVP

I recieved a list that contains names listed first name then last name in the
same cell. Is there a way to either sort last name first or to convert this
to separate the cells?
Click to expand...

Gord Dibben MS Excel MVP
 
T

Toppers

You will need to separate into two columns to sort:

Assuming names are separated by (at least) one blank then if data is A1:

in B1 (first Name) put =TRIM(LEFT(A1,FIND(" ",A1)-1))
in C1 (Lastname) put =TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)))

Copy these formulae down as required

TRIM will remove extraneous blanks.

Sort by Column C and then B

HTH
 
Top