separate names at comma

[sheri]

I am using Office XP. I need to take a column of names
that have last name followd by a comma then first name

EXAMPLE: Tingle, Sheri

I need to make this into two columns one for last names
and the other for first names.

IDEAS?? THANKS for the help!

 

[Alan Beban]

Insert as many columns to the right (so you don't overwrite anything), then
select your column and do Data|Text to columns. choose delimited by comma.

This will leave a leading space before the first name; choosing
delimited by comma *and* space will avoid this.

Alan Beban

 

[Dave Peterson]

Thanks for the correction.

This will leave a leading space before the first name; choosing
delimited by comma *and* space will avoid this.

Alan Beban