Delete empty spaces at the end of text of a column?

[nbaj2k]

I have a column that has different headings that I want to group
together. They are entries made by different people, some people for
one reason or another add an extra space or 2 with the spacebar after
the entry. When grouping these with a pivot table this makes it more
difficult as an entry with an extra space at the end won't group with
the entry without the space.

Is there a way to take a column that has many text entries and delete
any spaces after the last word of them?

Thanks,

~J

 

[Don Guillett]

look in help for
TRIM