Seperate a column into 2 columns

[Michele]

Someone once showed me a way to seperate a column that
contains data into two columns and I've forgotten how.
Here is what I currently have:

Name
Doe, John Smith
Smith, Jane Doe
Anyone, John Doe

But I need to break out the above column to look like this:

Last Name First Name
Doe John Smith
Smith Jane Doe
Anyone John Doe

I want to the breakout to based off of the comma. Any
input would be grateful so as to save me an hour's worth
of redesigning a query.

Thank you!
Michele

 

[JE McGimpsey]

One way:

Data/Text to Columns. CHoose Delimited, click Next, check the Comma
checkbox and click Finish

 

[Frank Kabel]

Hi Michele
try the following
- select your column
- goto 'Data - Text to Columns' and choose the coma as delimiter
- finish the wizard