How to look for a sequence of numbers in a string?

I am trying identify numbers that contain a specific sequence of numbers in
the entire string....ie 61302...I would be interested in identifying that
this string of numbers contained the sequence #13##. Can anyone help?

Hi Brett

=ISNUMBER(FIND("13",A1)) will return TRUE if 13 is present, otherwise FALSE.

Regards

Roger Govier


brett wrote:
> I am trying identify numbers that contain a specific sequence of numbers in
> the entire string....ie 61302...I would be interested in identifying that
> this string of numbers contained the sequence #13##. Can anyone help?

Use formula:

=IF(ISNUMBER(FIND("13",TEXT(A1,"#####"))),TRUE,"")

"brett" <[email protected]> wrote in message
news:[email protected]...
>I am trying identify numbers that contain a specific sequence of numbers in
> the entire string....ie 61302...I would be interested in identifying that
> this string of numbers contained the sequence #13##. Can anyone help?