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

--
HTH

Bob Phillips

"paul" wrote in message
...
shouldnt it be =IF(TRIM(RIGHT(D4,2))="XX",MID(D4,1,LEN(D4)-1),D4) if he
wants
to remove one of the two xxs??
--
paul
remove nospam for email addy!



"arno" wrote:

Hi Bob,
Works fine for me

it cannot work if you have trailing spaces.

arno