Text String Separation

T

TexasLegend

Is there a function opposite of "CONCATENATE"? I have a list of names
with the first and last names in the same cell. Doesn't do well if you
want to sort by last name. I diregress, rather than re-typing the whole
list I would like to know if anyone knows how to split the string at a
'space'.

Thanks for your help.
 
N

Niek Otten

Data>Text to columns
See HELP for more details, if it is not self-explanatory already
 
D

Dave Peterson

Maybe you could use
Data|Text to columns
delimited (by space)

But watch out for 3 name names: John Fitzgerald Kennedy
 
Top