Forum Discussion

leniorcortivo's avatar
leniorcortivo
Icon for Advocate I rankAdvocate I
5 years ago
Solved

Replace last blank characters in a cell

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.

Need Help
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    5 years ago

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

     

    Pat

     

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

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

     

    Pat

     

  • leniorcortivo's avatar
    leniorcortivo
    Icon for Advocate I rankAdvocate I
    5 years ago

    Hello Pat, 

     

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

     

    I have used Text.TrimEnd funcion.

     

    Thank you.