I tried the simpliest thing:
But if I did this:
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.*")