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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com> wrote in
message news:cjjoo.1ux06d_1125972327.6323@excelforum-nospam.com...
>
> 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
>