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