I would like to use RTrim
to remove spaces from a list of single words.

Every example of RTrim I can find on the web
seems to be for a paticular fixed string like "Hello World ".

If I want to use: RTrim( text )
with 'text' as a variable
to loop down a list, if possible
and remove the trailing spaces
can I substitute something for 'text'
to identify the cell contents ?

That is, how would the following look?

Sub Macro1()
Do Until ActiveCell.Formula = ""
ActiveCell.Offset(1, 0).Select
RTrim( text )
Loop

Thank you,
Emory