Works fine for me, what do you get?

--
HTH

Bob Phillips

"Muhammad Nasir" <Muhammad wrote in message
...
plz remove error from the formula? If any one can help. My excel sheet
contains values like 561XX, I want to remove the right most X from the
text.