splitting names into columns

B

bluegirl

I have a sheet that has peoples names listed in this format:

Jim Jones
Jacob R Jones
Allen W Bush Jr

And I need to organize them so they arein this format:
last name, first name mi

I have been tryin to split the information into seperate cells so I ca
move the columns around and the squish it all back together... but i
is not working..

Can anyone help?

Thanks in advanc
 
R

rbanks

This is crude, but works like a charm.

Take the list of names out to a blank workbook, and save as a tex
file.

Then open the text file with excel, choose, "delimited", next
"space".

Then your file should have 1st names in column a, middle initial in b
and last in column c.

Then in cell d1: =CONCATENATE(C1,", ",A1," ",B1)

See attached file. You may have to manually adjust those with Jr o
the end, or no Middle Initial.

When done, you can paste your results back to your source worksheet.

see exampl

Attachment filename: names.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52928
 
Top