Hi Arvi,

Why did you say

=COUNTIF(A1:A96,"*"&"VVN"&"*")

instead of

=COUNTIF(A1:A96,"*VVN*")

just wondering?

Bob

"Arvi Laanemets" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> =COUNTIF(A1:A96,"*"&"VVN"&"*")
>
> --
> Arvi Laanemets
> ( My real mail address: arvil<at>tarkon.ee )
>
>
> "Paul W" <[email protected]> wrote in message
> news:[email protected]...
> > I'm trying yo count the number of occurances of a string in a variable
> > string
> > e.g look for "VVN" in TDCS0/VVN/8375 or mycompany/VVN/8375 or even
> > mycompany/TDCS0/VVN/8375. The text does not appear in the same location
> > each
> > time. so what i am looking for is countif(a1/a96="VVN anywhere in this
> > string")
> >
> > Excel 2002
> >
> > Help !
> >
> >
> >
> >
> >
>
>