Detect double digit
Hi
Try
=IF(LEN(A1)<2,"",MID(A1,LEN(A1)-1,1)=RIGHT(A1))
--
Regards
Roger Govier
"ShamsulZ" wrote in message
...
I'm looking for a formula that enable me to detect any no. of last 2
digit
that is the same for e.g 1233, abcd2345677, 90566 etc. Thanks for your
help
|