|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 27th, 2005, 01:35 AM
|
|||
|
|||
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? 
|
|
#2
October 27th, 2005, 01:41 AM
|
|||
|
|||
|
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?
|
|
#3
October 27th, 2005, 01:44 AM
|
|||
|
|||
|
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
| Correcting out of sequence Figure numbers | Jeff | New Users | 2 | May 12th, 2005 07:00 PM |
| Can i convert numbers into string format? | talia_k | General Discussion | 3 | April 28th, 2005 03:27 PM |
| What if the back-end "moves"? | John S. Ford, MD | General Discussion | 13 | November 15th, 2004 09:33 PM |
| how do i get numbers from a text string | Zack D | General Discussion | 3 | November 3rd, 2004 11:31 PM |
Linear Mode
