Thread: =IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error
View Single Post
  #3   Report Post  
arno
 
Posts: n/a
Default
=if(right(trim(D4);1)="X";left(D4;len(trim(D4))-1);D4)

pls. use , instead of ; in the formula!
arno
Reply With QuoteReply With Quote