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

Reply With QuoteReply With Quote