how to separate text with commas in it

[compman]

How do I spearate first and last names spearted by a comma? I have 21,000+ names in our database with last name,first name. I need to break out the names into 2 separate columns. Can anyone help me.

 

[lenze]

Use Data>Text to Column. Select the delimitor option and check the comma box. Just follow the wizard.
This message was edited by lenze on 2002-10-02 13:25

 

[compman]

TO:lenze
MrExcel MVP

Thank you very much. What part of Montana are you from? I used to live in Ennis as a kid.

 

[lenze]

Helena, but I'm originally from Texas

 

[Jammer]

Hi.

I used the Data, Text to Columns, with a space, but often get asked what to do when the name is complex, such as Last Name = Da Silva or Van De Kamp (not simple like Smith). What do you do then. I have seen a formula for this before. Thank you.

 

[jmuscat]

Formula for splitting firstname and lastname
=LEFT(B5,(FIND(" ",B5)))
=RIGHT(B6,(LEN(B6)-(FIND(" ",B6))))