Hi,

You can obtain the desired result by using Data Text to columns. The
steps should be self explanatory

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

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