Alphabetical Lists
 

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?

Alphabetical Lists
 

CW wrote:
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?

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

Alphabetical Lists
 

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.

"CW" wrote:

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?

Alphabetical Lists
 

See the Text To Columns tool on the Data menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CW" wrote in message
...
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?

Alphabetical Lists
 

CW

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

It may as simple as DataText to ColumnsDe-limited bySpace.

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

On Tue, 11 Jul 2006 07:51:02 -0700, CW wrote:

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?

Gord Dibben MS Excel MVP

Alphabetical Lists
 

Thanks everyone!

"Chip Pearson" wrote:

See the Text To Columns tool on the Data menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CW" wrote in message
...
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?

Alphabetical Lists
 

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

"CW" wrote:

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?