remove tail spaces

R

RichHoughton

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
 
B

Bob Phillips

=TRIM(A1)

--
HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 365 overriding formatting choices 0
White space above heading inconsistently applied 1
Formating bolded text exclusively. 0
Remove Identical words 0
Remove non-space spaces? 3
Spaces at the end of data 5
Vlookyp fails due to space at the end 2
How do I remove extra space when text wrapping? 2

Top