If, for all cells, first and last names are written with a space between, you
can use the text to column tool, choose the option "delimited" and tick
"space" option. Then you'll have all names separated in 2 columns.
"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!
|