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

[brett]

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?

[Roger Govier]

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?

[Mladen_Dj]

Use formula:

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

"brett" <brett@discussions.microsoft.com> wrote in message
news:87D2A64B-172B-4CD5-9AEC-78F089DB98BC@microsoft.com...
>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?