One way, in B2, copied down:
=SUMPRODUCT(--ISNUMBER(SEARCH({"a","d","l","r"},A2)))0
Replace SEARCH with FIND if you need it case sensitive. SEARCH is not case
sensitive.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NeedExcelHelp07" wrote:
ok but what if the codes are written like a7?
How can I write the formula so it searches for the "a" even though the 7 is
in the cell as well?