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

G

Guest

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?
 
R

Roger Govier

Hi Brett

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

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking for next number in sequence 2
VBA: How can I use a string variable as autofilter criteria? 4
re-numbering or sequence priorities formula 2
running number sequences 1
use row numbers from a list in subsequent formula 1
Display Missing invoice numbers from a sequence. 2
Numbering rows 6
Excel number sequencing formatting 8

Top