name separation

[Help with Cell question]

how do i separate a single cell name "Doe, John" into two separate cells?

 

[Mike H]

Hi,

text in a1

First part
=LEFT(A1,FIND(",",A1,1)-1)

Second part
=TRIM(MID(A1,FIND(",",A1,1)+1,LEN(A1)))

Mike

 

[Gary Brown]

Assuming 'Doe, John' is in Cell A1...
=LEFT(A1,FIND(", ",A1)-1) equals 'Doe'
=RIGHT(A1,LEN(A1)-FIND(", ",A1)-1) equals 'John'
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown

 

[Rick Rothstein \(MVP - VB\)]

If you are asking this because you have a column of names like that in
single cells, you can select all the names in the column, click Data/Text To
Columns on Excel's menu bar; select the Delimited option on the Step 1
dialog page and click Next; put a check mark in the Space, Comma and "Treat
consecutive delimiters as one" check boxes and then click Finish.

Rick


"Help with Cell question" <Help with Cell
(e-mail address removed)> wrote in message
news:[email protected]...