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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine multiple columns and rows for one record into one row. 2
concatenate 2 columns (A2+B2) and compare for duplicates 3
Excel Comparing two columns 1
Find last row 1
vlookup using match and date range 1
Reference a column to make groups 1
Counting Names in a Column, Ignoring Duplicates 8
Summing Fields with Multiple Criteria 1

Back
Top