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