Split data from one cell to two separate cells

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

Hi there,

Assuming it's in A1

Last:
=LEFT(A1,FIND(",",A1,1)-1)

First:
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

If that is all the permutations you'll have, then you should be set. If you
happen to have any other names, middle initials, suffixes, then you'll need
another approach. Chip Pearson lines it out very well on his site here ...

http://www.cpearson.com/excel/FirstLast.htm

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"Michele" <[email protected]> wrote in message
news:[email protected]...
> How do you take "Smith, John" from one cell and create one cell with
> "Smith"
> and another with "John"? Basically, the reverse of Concatenation.

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.