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

<colgroup><col width="64"></colgroup><tbody>
</tbody>

 

[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:

Beyblade: Metal Fusion | El Pegasus plateado - Ep. 17 | CASTELLANO!

<colgroup><col width="498"></colgroup><tbody>
</tbody>

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.