want to split cell data into two seperate cells... 1

[fowlerlfc]

i have data in one cell formatted like: smith, bob. i want to split that data into two cells. one for the firstname and one for the lastname.

i'm not asking anyone to write a formula for me, but if you could maybe just give me guidance on which functions to look at i would be very grateful.

thanks in advance!

 

[jonsi]

Try Using Data>Text to Columns.

You need to choose Delimited and then make sure that the Comma box is ticked as your separator.

 

[fowlerlfc]

that worked thanks!