Text String Separation

[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.

[Niek Otten]

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

--
Kind regards,

Niek Otten

"TexasLegend" <jrhughson@gmail.com> wrote in message
news:1135807231.369309.264310@f14g2000cwb.googlegroups.com...
> 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.
>

[Chip Pearson]

You can use the Text To Columns tool on the Data menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TexasLegend" <jrhughson@gmail.com> wrote in message
news:1135807231.369309.264310@f14g2000cwb.googlegroups.com...
> 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.
>

[Dave Peterson]

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

But watch out for 3 name names: John Fitzgerald Kennedy



TexasLegend wrote:
>
> 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.

--

Dave Peterson