I have a spreadsheet with 400 names listed lastname, firstname in once cell.
Is there a function in Excel that would create two cells, one cell for
lastname, and another cell for firstname? I'm not looking for the individual
cell cut and paste option.

Thanks,

Pete