View Single Post
  #4   Report Post  
Duke Carey
 
Posts: n/a
Default

In the Text to columns feature, use Delimited instaed of Fixed Width, and use
a space as the delimiter. You'll have to eyeball the results to deal with
names like Jill St. John



"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!