How do I - Strip last letter from field

  • Thread starter Thread starter Benjamin
  • Start date Start date
B

Benjamin

I want to strip the last character from a cell, but only if it is a number.
0040:P0200C would return C
040:PT1C would return C
0040:P202 wouldn't return anything or null
 
Try the below formula with the data in cell A1

=IF(ISNUMBER(RIGHT(A1,1)+0),"",RIGHT(A1,1))

If this post helps click Yes
 
Back
Top