Abstracting text

[Bill Ridgeway]

I have a column containing names which have two elements (of differing
length) separated by a space. I am looking for formulae which will return
the two elements separately (preferably without the intervening space).

Thanks.

Bill Ridgeway

Hi

Make a copy of your sheet first and then go to Data / Text to columns and
follow the instructions. Use delimited and have <space> as delimiter.

Andy.

"Bill Ridgeway" <info@1001solutions.co.uk> wrote in message
news:e54cs3$q5f$1@newsg1.svr.pol.co.uk...
>I have a column containing names which have two elements (of differing
>length) separated by a space. I am looking for formulae which will return
>the two elements separately (preferably without the intervening space).
>
> Thanks.
>
> Bill Ridgeway
>

[Bill Ridgeway]

Thanks Andy. It's much easier than I thought it would be!

Bill Ridgeway

<Andy> wrote in message news:OsmEGNAgGHA.3860@TK2MSFTNGP02.phx.gbl...
> Hi
>
> Make a copy of your sheet first and then go to Data / Text to columns and
> follow the instructions. Use delimited and have <space> as delimiter.
>
> Andy.
>
> "Bill Ridgeway" <info@1001solutions.co.uk> wrote in message
> news:e54cs3$q5f$1@newsg1.svr.pol.co.uk...
>>I have a column containing names which have two elements (of differing
>>length) separated by a space. I am looking for formulae which will return
>>the two elements separately (preferably without the intervening space).
>>
>> Thanks.
>>
>> Bill Ridgeway

Thanks for the feedback - glad you're sorted!

Andy.

"Bill Ridgeway" <info@1001solutions.co.uk> wrote in message
news:e54iej$t6c$1@news7.svr.pol.co.uk...
> Thanks Andy. It's much easier than I thought it would be!
>
> Bill Ridgeway
>
> <Andy> wrote in message news:OsmEGNAgGHA.3860@TK2MSFTNGP02.phx.gbl...
>> Hi
>>
>> Make a copy of your sheet first and then go to Data / Text to columns and
>> follow the instructions. Use delimited and have <space> as delimiter.
>>
>> Andy.
>>
>> "Bill Ridgeway" <info@1001solutions.co.uk> wrote in message
>> news:e54cs3$q5f$1@newsg1.svr.pol.co.uk...
>>>I have a column containing names which have two elements (of differing
>>>length) separated by a space. I am looking for formulae which will
>>>return the two elements separately (preferably without the intervening
>>>space).
>>>
>>> Thanks.
>>>
>>> Bill Ridgeway
>
>