How do I separate cell contents into 2 cells using a comma as the marker?

[jfarlow]

e.g.
one cell shows
lastname, firstname

and I want to break it out into 2 separate cells with lastname in one and firstname in the other......

any suggestions?

thanks!
jo

[StephenR]

Try Data > Text to Columns > Delimited > Select comma > Finish.

[oldchippy]

Hi,

You can do that with a formula in B1

=LEFT(A1,FIND(",",A1&",")-1)

and in C1

=TRIM(REPLACE(A1,1,FIND(",",A1&","),""))