How can I delete all spaces after the last non-space character in each
cell?

Excel's TRIM function does a little more than you mentioned, but it might
be what you want.