Thank you for your reply, I was trying to trim a string from the right with number of characters, it seem that should be done in 2 steps!

Hi, Hani Fathi.

I have just checked the formula and everything seems to be working fine!

This formula is meant to "Pad a text to the left with extra characters", meaning that you need to supply two strings of text and the width of the resulting text. On the provided screenshot, I have added "ABC" to the left of "random" with "10" set as the width of the resulting string.

Check our reference documentation if you want to see more examples: