Expanded FIND function (3 is found when the cell contains 1-5)

You don't say if those examples represent the values in two cells, one cell having 33214.33222 etc.
but yes, using a search or find function and pointing it at a cell can return a positive if a 3 is found in a cell.
something like this... =IF(ISNUMBER(SEARCH("3",A2)),"yes 3","no 3")

Oh yeah - let me amend that snippet I took. Those are supposed to be commas, not dots/periods. So the picture in the OP reads as follow. And keep in mind the there's #s cut off :

33214, 33222-33231, 33241, 33249, 33262-33264, 332
0-93042, 93224-93299, 93279-93464, 93600-93622, G

So in your reply, if the commas represent cells, then one cell would instead be 33214, not 33214.33222. Again, sorry for the poor quality of the snippet.

So yes, I see your solution would find the number 3 if the cell contained a 3 (eg. 33214.33222 contains the number 3).

Would it find the number 33229, which exists in the above snippet or in a cell that contains 33222-33231?
Would it find the number 93000, which also exists in 93279-93464?
Would it find 3 in a cell that contains 1-5?

I dont think it will. But I do think you've supplied an important thought on a larger solution - gave me an idea.

So I'm thinking a macro that identifies the dash (or minus-sign, whatever) - anyways it identifies the "-", then splits the cell on either side of the "-" making the left side the low number; right side the high number, then calculates for TRUE using operators <= and => and if both operators are TRUE then the search-term is within the range. In fact the macro goes through every cell in the list dash and no-dash. No dash means there's only one number in the cell and to calculate for TRUE as above cause either the #s going to equal the search-term or not (no need to program more calculations into the macro). The macro completes this for a range and spits out the result.

Thank you for your reply.

Could you post a sample workbook (instructions in the yellow bar at the top of the post) that contains some actual samples (not many needed) AND your expected solution to a couple so I (we) can get an idea of a formula to write. A macro may not be necessary or it may but I'm not sure I completely follow your description of your data and needs.

Unless you do the +0, Excel sees the formula result as text. Adding 0 is one way to coerce Excel into seeing the text value as a number.