So do you still have a problem, or was Arno's response working for you?

--
HTH

Bob Phillips

"Muhammad Nasir" <Muhammad wrote in message
...
Hi. Bob and Arno
thanks for spending time for me. Yes I have leading and trailing spaces in
the specific column thats why i used Trim. Error always comes on ="X"
part. I
also used single quotes but invain. I dont want to remove double x i'.e.
xx

thnaks again

"arno" wrote:

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