Hi Bob,
He doesn't, he specifically said just the right-most X.

any single X in the string is the right-most X.

So, Muhammad, pls. tell us:
- Do you have leading or trailing spaces (this would explain the
trim-function in your formula)?
- Do you want to remove an X if it is the last character of the string?
Or do you want to remove only the second X of XX at the end of the
string, or... whatever, just tell us.

arno