Thread: =IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error
View Single Post
  #2   Report Post  
arno
 
Posts: n/a
Default
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.

=if(right(trim(D4);1)="X";left(D4;len(trim(D4))-1);D4)

arno

Reply With QuoteReply With Quote