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