Home > Mobile >  Wildcard character does not behave as a wildcard in google spreadsheet
Wildcard character does not behave as a wildcard in google spreadsheet

Time:03-09

I tried the simpliest thing:

enter image description here

But if I did this:

enter image description here

the expression was TRUE. So it seems the * character does not behave as a wildcard. What is the problem here?

CodePudding user response:

You cannot use wildcards with the = operator.

Try this instead:

=regexmatch(A1,"^maki.*")
  • Related