View Single Post
  #1   Report Post  
Vanessa
 
Posts: n/a
Default How do I separate words in one cell into two cells?

I have a column that has both first and last names in it. I would like to
separate the two into two separate columns. The text to column feature
doesn't work (at least how I know to use it) because the people's names are
of such different lengths. Can anyone help me so I don't have to manually
separate hundreds of names?
Thanks!