Thread: How do I separate a name into 2 columns from Surname, christian n.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How do I separate a name into 2 columns from Surname, christian n.
Data Text to Columns follow the wizard


"Phil B" wrote:

I have a list of names in the format "surname, christian name" and want to
separate the two names so I have the surname and christian names in different
columns. Is there a function formula to do this?
Reply With QuoteReply With Quote