DataText to Columns and choose a delimiter of comma

--
HTH

Bob Phillips

"Elise" wrote in message
...
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