how do I separate last, first names from 1 column into 2 columns?

R

RonaldoOneNil

Highlight your data and then select Data, Text to Columns and follow the
prompts in the wizard.
 
W

willwonka

Example:

Doe, John (in 1 column) to   Doe    John in separate coumns.

Thanks!
Click to expand...

Take a look a Data, Text to Columns and use delimited text and use the
comma as your delimiter.
 
S

SDoc

Thank you for your assistance! I am working on an Access Database and
importing info - Will probably be asking lots of questions! Have a great day!
 

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 do I separate first and last names into two columns? 2
Help! Excel Question 5
Show all values in first column of Pivot Table 1
Populate excel sheet based on values in a separate sheet 3
Excel Comparing two columns 1
Data separation 1
complicated text to column 4
restrict columns that have auto filter 1

Top