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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to look for a sequence of numbers in a string? (https://www.excelbanter.com/excel-discussion-misc-queries/52467-how-look-sequence-numbers-string.html)

brett

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?

Roger Govier

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

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

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

Use formula:

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

"brett" wrote in message
...
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?

All times are GMT +1. The time now is 09:46 PM.