how to parse out a NAME column into 2 seperate cells - one for LastName and 2nd for First

[cirugio]

I currently have a spreadsheet which has a column called NAME. This column contains the Lastname, Firstname in the same cell. Is there a formula which will parse the last name and first name into two separate cells?

For example, my spreadsheet contains the following:

col A Col B

Name Address

Smith, John 1234 Lake Street, Chicago
Jones, Sally 3930 Hollywood Street, Chicago


I would like the excel spreadsheet to parse out the lastname from the firstname and put it in seperate columns, like this:


col A Col B Col C Col D

Name Address Lastname FirstName

Smith, John 1234 Lake Street, Chicago Smith John
Jones, Sally 3930 Hollywood Street, Chicago Jones Sally

[OllieB]

On the DATA section of the Ribbon there is a function called Text to Columns. Select Column A and click on this button, specify that the contents are delimited by a "," and that the output should be to columns C:D. Presto!