Hi,

If I have cells that contain text entries with various combinations of 25, 20, 15, 10, 5, 2.5, 1.25, 1, 0.75, 0.5 and 0.25 (separated by commas if a cell contains more than one)

So, for example, one cell could contain:

25, 15, 5, 1.25

And another cell might contain just one number (though it will be entered as text (the result of a formula elsewhere) not as a number).

If I want to know which of the numbers are there, how would I do that?

So, for example, if a cell has both 25 and 1.25, and another cell has 1.25 only, how would I tell the difference? It seems to me that using =FIND("25",A1) isn't enough, or is it?

Thanks in advance.