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!

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!
 
Top