Script to remove spaces at end of text

Is there any script you can generate to remove spaces from the end of some known text, that appears randomly in a cell(s) of a column?

Say "TEXT " to "TEXT"

Thanks for your help

Use the TRIM function.


- Mangesh

Hello Sonic,

MyText = RTrim("TEXT ")

MyText will equal "Text"

There are 3 Trim functions, all of which remove spaces.

Trim(String) removes both leading and trailing spaces
LTrim(String) removes Leading spaces (Left Side)
RTrim(String) remoces Trailing spaces (Right Side)

Sincerely,
Leith Ross

Thanks very much for your replies, mangesh_yadav and Leith Ross.

That worked the trick!
I Realised when you suggested "Trim", I have used this function before.
Thanks for your help