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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>