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

--
Don Guillett
SalesAid Software
[email protected]
"nbaj2k" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> nbaj2k
> ------------------------------------------------------------------------
> nbaj2k's Profile:
> http://www.excelforum.com/member.php...o&userid=36480
> View this thread: http://www.excelforum.com/showthread...hreadid=569399
>