.... or you could simplify to =IF(ISNUMBER(RIGHT(A1)+0),"",RIGHT(A1))
--
David Biddulph

"Jacob Skaria" wrote in message
...
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