Data - Text to Columns, delimited, use comma as the separater. HTH
--
Sincerely, Michael Colvin


"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