Data separation



I currently have a spread sheet that has the first and last name in one
column as, Smith, John. I really need to break these names apart and have
them populate two separate colums. Any suggestions?




Highlight the column then do text to columns, delimited, check the box that
says comma, next, finish
it will split in two columns

if this helps please click yes, thanks

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 separate Smith, John 2
splitting Last Name, First Name 4
Drop down box! 1
Replacement for multiple spreadsheets 3
Excel Comparing two columns 1
Auto populate name 2
Auto-Alphabetize 1
separating first and last names 10