Converting one column into two

  • Thread starter Thread starter Michele
  • Start date Start date
M

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
 
Hi Michele
see your answers in Excel.worksheet.functions
P.S.. please don't multipost as this scatters your answers
 
Back
Top