Hi

I'm trying to remove spaces from the end of text without success. A cell
contains for example: The(space)Cat(space)Sat(space)(space)(space)(space )
What i want is: The(space)Cat(space)Sat

What i am trying to do is search from the right, the first non-space
character, get it's position value in the overall cell length and with the
use of the Len function, remove all spaces after the final character. Please
note that the number of words in each text piece vary.

Any ideas please?
Rich

=TRIM(A1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RichHoughton" wrote in message
...
Hi

I'm trying to remove spaces from the end of text without success. A cell
contains for example: The(space)Cat(space)Sat(space)(space)(space)(space )
What i want is: The(space)Cat(space)Sat

What i am trying to do is search from the right, the first non-space
character, get it's position value in the overall cell length and with the
use of the Len function, remove all spaces after the final character.
Please
note that the number of words in each text piece vary.

Any ideas please?
Rich

Brilliant, thanks

"Bob Phillips" wrote:

=TRIM(A1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RichHoughton" wrote in message
...
Hi

I'm trying to remove spaces from the end of text without success. A cell
contains for example: The(space)Cat(space)Sat(space)(space)(space)(space )
What i want is: The(space)Cat(space)Sat

What i am trying to do is search from the right, the first non-space
character, get it's position value in the overall cell length and with the
use of the Len function, remove all spaces after the final character.
Please
note that the number of words in each text piece vary.

Any ideas please?
Rich