View Single Post
  #1   Report Post  
maryj
 
Posts: n/a
Default splitting text to multiple columns

I have a list of people's names in a cell. Some examples a
Mr. John Doe
Mrs. Jane S. Smith
Ms. Cynthia Jones

I need to split their titles, first name with Middle initial and Last name
into 3 seperate columns. Using a post on this site, I was able to extract
the title, but am unsure how to pull the other information.

Thanks for you help!