Re: Abstracting text

Giganews Newsgroups
Subject: Re: Abstracting text
Posted by:  Andy
Date: Thu, 25 May 2006

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" <in…@1001solutions.co.uk> wrote in message
news:e54cs3$q5f$…@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

Replies

In response to

Abstracting text posted by Bill Ridgeway on Thu, 25 May 2006