View Single Post
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

First, I'm assuming that there is a first name and a last name and no middle
name. If there is, you'll still have to do some data manipulation. This
should get you part of the way.

Data - Text to Columns
Select "Delimited"
Select "Space"
Select "Finish"
"Vanessa" wrote:

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!