Are you looking for its position in the string? This gives the first
position of the first pair in the string

=MIN(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1)-1)),1)=MID(A1,ROW(INDIRECT("2:"&LEN
(A1))),1),ROW(INDIRECT("1:"&LEN(A1)-1))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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