Thread: how do I separate last, first names from 1 column into 2 columns?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
SDoc SDoc is offline
external usenet poster
  
Posts: 2
Default 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!

Reply With QuoteReply With Quote