Converting one column into two

[Michele]

I need to convert the following column:

Name
Doe, John Smith
Smith, Jane Doe
Anyone, John Doe

I need it to look like this:

Name First Name
Doe John Smith
Smith Jane Doe
Anyone John Doe

I know there is a way you can specify this action based on
the comma, but I cannot remember for the life of me. I
have a spreadsheet with 10K+ names on it and I would
prefer to not spend an hour re-writing the query to do
another information retreival. Any help would be greatly
appreciated!

Thank you!
Michele

 

[Frank Kabel]

Hi Michele
see your answers in Excel.worksheet.functions
P.S.. please don't multipost as this scatters your answers