Thread
:
=IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error
View Single Post
#
5
arno
Posts: n/a
Hi Bob,
Works fine for me
it cannot work if you have trailing spaces.
arno
Reply With Quote