Asterisk as WildCard

Hi,

I believe the asterisk can be used as a wildcard, but I'm having some problems with my formula.

Please Login or Register  to view this content.

This always results in false. I know I could write this using the LEFT formula, but I'm trying to minimize the the levels of nesting if possible. Any ideas?

The asterisk wildcard does not work with arguments separated by = sign.

It works with comma separated arguments like in Countif or Sumif

e.g. =Countif(A1:A100,"standard*")