Do a "Text to Column" under "Data". Be sure to insert an extra column before
you split your text first.

"Elise" wrote:

I have spreadsheet that has a column for names. The names have been input as
follows: lastname, firstname". Is there a way to copy the first name to a
new column and the last name to a different column?
--
Elise King-Lynch