Can you make use of a macro in your workbook? If so, right click the
worksheet tab, select View Code from the pop up menu that appears and
copy/paste the following into the code window that appears...
Sub RemoveTrailingBlanks()
Dim C As Range
For Each C In Selection
C.Value = RTrim(C.Value)
Next
End Sub
Go back to the worksheet, select all the cells you want to remove trailing
blanks from (it is alright to select a range containing cells both with and
without trailing blanks, the code will not be bothered by such a mixture),
key in Alt+F8, select RemoveTrailingBlanks from the list and click the Run
button.
Rick
Excel's TRIM function does a little more than you mentioned, but it might
be what you want.
TRIM removes ALL extra spaces in the cells (not just at the end).