Text String Separation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TexasLegend - 28 Dec 2005 22:00 GMT

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.

Reply to this Message

Niek Otten - 28 Dec 2005 22:06 GMT

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

Signature

Kind regards,

Niek Otten

> 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
[quoted text clipped - 3 lines]
>
> Thanks for your help.

Reply to this Message

Chip Pearson - 28 Dec 2005 22:06 GMT

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

Signature

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

> Is there a function opposite of "CONCATENATE"? I have a list of
> names
[quoted text clipped - 7 lines]
>
> Thanks for your help.

Reply to this Message

Dave Peterson - 28 Dec 2005 22:13 GMT

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

But watch out for 3 name names: John Fitzgerald Kennedy

Signature

Dave Peterson

Reply to this Message