Abstracting text

's Computer Specifications

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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:e54cs3$q5f$(E-Mail Removed)...
>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
>

's Computer Specifications

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

Bill Ridgeway

<Andy> wrote in message news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:e54cs3$q5f$(E-Mail Removed)...
>>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

's Computer Specifications

Thanks for the feedback - glad you're sorted!

Andy.

"Bill Ridgeway" <(E-Mail Removed)> wrote in message
news:e54iej$t6c$(E-Mail Removed)...
> Thanks Andy. It's much easier than I thought it would be!
>
> Bill Ridgeway
>
> <Andy> wrote in message news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:e54cs3$q5f$(E-Mail Removed)...
>>>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
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help, abstracting classes	Snedker	Microsoft C# .NET	2	7th May 2009 02:39 AM
Abstracting text from WORD into Excel	=?Utf-8?B?Um9iaW4gQ2xheQ==?=	Microsoft Excel Misc	2	11th Jul 2006 04:34 PM
abstracting a web service	nevin	Microsoft C# .NET	2	4th May 2004 11:09 PM
Abstracting Connection objects	Frank Rizzo	Microsoft C# .NET	1	17th Jul 2003 01:38 AM
Abstracting and recreating forms	Paul	Microsoft Dot NET Framework Forms	0	25th Jun 2003 09:23 AM