commas and names

[abanky]

i have a cell, like this (last name, first name) i want the last name to go to one cell and the first name to go to one cell how do i do this?

 

[Smitty]

Select the range that contains the names and goto Data-->Text To Columns-->Delimited-->Comma-->Finish.

Make sure that you have a blank column to the right beforehand though.

Hope that helps,

Smitty