Replace last blank characters in a cell

[leniorcortivo]

Dear Coleagues, 

I have the following situation.

The Desired result that I am expecting to achieve is remove just the last blank characteres but not the blank in the middle of the code, that is part of the code.

I have tried several functions but without success. I appreciate all suggestions and help.

Thank you.

[leniorcortivo]

Hello Pat, 

Thanks for the tip! I tried and it worked perfectly.

I have used Text.TrimEnd funcion.

Thank you.

[mahoneypat · Accepted solution]

Have you tried the Trim function on the Transform tab under the Format pull down?

Pat