And also changes multiple internal spaces to single spaces.

John Bundy wrote:

=trim() takes excess spaces off the front and back
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Roger" wrote:

I need to remove spaces (blank) from the end of a line of text. I ususally
would simply find and replace, but in this case the text has spaces with in
it that I do not want to remove, I only want to clear the spaces after the
text, can anyone help?

thanks in advance.

--

Dave Peterson