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
wrote in message
...
how do i separate a single cell name "Doe, John" into two separate cells?