If function searching for number in text string if number is between values

[jdodge]

Hi All,

Hoping someone can help me out with this function: I have a huge sheet with 20,000 rows that contain text and somewhere within that text a number from 1-200. I'm trying to write an If formula that will tell me if the number in the text string is between two values (1-14), but the numbers are not in a uniform place in the text strings.

This is what I have so far: =IF(ISNUMBER(SEARCH(AND(A5>0,A5<14),A5))=TRUE,"Y","N")

The obvious problem I'm having is in red, where I can't figure out how to phrase the above or below value.

Any help is appreciated!

Thanks,
J
[TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[/TR]
</tbody>[/TABLE]

 

[AlKey]

Can you provide an example of the text string and show the desired results?

 

[jdodge]

Sure, it's a list of TV show. For example:

[TABLE="width: 498"]
<colgroup><col width="498"></colgroup><tbody>[TR]
[TD="width: 498"]Beyblade: Metal Fusion | El Pegasus plateado - Ep. 17 | CASTELLANO!
[/TD]
[/TR]
</tbody>[/TABLE]
Beyblade Metal Fusion eps 41
Bakugan Battle Brawlers: The Good, The Bad and The Bakugan | Ep. 50 | ENGLISH!
Beyblade: Metal Fusion | Le Rugissement de Leone - Ep. 2 | FRANÇAIS!
Beyblade: Metal Fusion | Hrôzostrašná Libra - Ep. 22 | SLOVENČINA!
Bakugan Battle Brawlers: A Little Help From My Friends - Ep.20

Thanks!
J

 

[jdodge]

Sorry, the desired results would be, for example, the first one would return N as the number in the text string is more than 14.