Extracting names in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of names Adams,John William which I wish to extract to
seperate columns John in a coloum and Adams in another.
 
Try Data/Text to Columns... Select Delimited, click Next, and check the
comma (and if desired, the space) characters. If you dont' want the
Middle name, click Next, select the third column and choose the Do Not
Import radio button then click Finish, otherwise, just click Finish.
 

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

How to compare and extract data in two columns 1
Combine names seperated by comma 3
extract names based on conditions 2
sorting rows 1
return multiple entries from vlookup 2
Using wild card in IF formula 3
HOW DO I COMBINE two spreadsheets into one by names in column a 3
Excel ALERT a duplicate of the match of two cells in two different columns... please 0

Back
Top