Hi Micelle,
If in A1 then select this cell then you should also try out
the Data Text to Columns then follow instructions.

Regards
Graham Haughs

Michele wrote:
How do you take "Smith, John" from one cell and create one cell with "Smith"
and another with "John"? Basically, the reverse of Concatenation.