If those spaces are the non-breaking space character (with a code of
160), then TRIM and CLEAN will not remove them. But, you could use the
SUBSTITUTE function, or you can do it in one operation by highlighting
the cells affected, and CTRL-H (or Edit | Replace):

Find what: Alt-0160
Replace with: leave blank
then click Replace all,

where Alt-0160 means hold the Alt key down while you enter 0160 on the
numeric keypad.

Hope this helps.

Pete

On Aug 17, 7:59*pm, GARY wrote:
How can I delete all spaces after the last non-space character in each
cell?