How do I evaluate on numeric characters within a string?

[ndalum88]

I have a strange issue I'm dealing with and wondering if anyone knows of a way to do it. I have a cell that references another cell. If the source cell has a string somewhere in it that consists of " AL" the output cell will display the product name "Avloy". I am finding that this is incorrect, as the source cell is a product description, and in some instances has "Alkaline" or something like that in it, leading to an incorrect result. So......I'm trying to select only the items that have " AL" and the next character being NUMERIC only; the real probelm is that the string can appear anywhere in the source cell. Anyone have any ideas??? Thanks!

Kevin

[Hedwigkin]

Kevin,

Assuming that a numeric character always follows the " AL", you could try the following:

=IF(ISERROR(SEARCH(" AL",A1)),"",IF(ISERROR(1*MID(A1,SEARCH(" AL",A1)+3,1)),"","Return Product Name Function Here"))

Where A1 contains the string containing the " AL"

Hope this helps.

-Jeff