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