Perhaps in say, B1: =COUNTIF(A1:A10,"*RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" wrote in
message ...

i have tried it before but it does not work! sob sob . Any more
suggestions? tks


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=401872