Looking a Way to Kill Extra Space at the end of value

I have 2 columns. Values in column A also exist in column B, but not all. I have conditional formula in column C that displays 'TRUE' or 'FLASE' if identical value from Column A exist in column B.

But the problem is some values in columns B contain extra space at the end of value therefore condition formula shows 'FLASE' when infact value from columns A exist somewhere in Column B but extra space make Excel think it is different.
i.e.

A1 value = U S A
B82 value = U S A

'U S A' does exist in column B but I will get false value in C1 because of extra space at the end.

So What I trying to accomplish is delete any extra space ONLY at the end

I tried CNTRL + H but It will replace ANY SPACE whereever it finds but I want to delete only at the end.

Any help will be appreciated.

Hello ccuser,

Provided you don't need leading spaces you can you use the TRIM function to remove both leading and trailing spaces.

Example

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks so much. I was looking for exact same thing and found it on this post. Saved me tons of time.

Keep up the good work.