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

Example:

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

Thanks!

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

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

"SDoc" wrote:

Example:

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

Thanks!

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

On Jun 26, 10:16*am, SDoc wrote:
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.

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

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!

"RonaldoOneNil" wrote:

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

"SDoc" wrote:

Example:

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

Thanks!