Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--