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
---------------
Jacob Skaria


"Benjamin" wrote:

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