[SOLVED] Wildcard character does not behave as a wildcard in google spreadsheet

Issue

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?

Solution

You cannot use wildcards with the = operator.

Try this instead:

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

Answered By – ztiaa

Answer Checked By – Senaida (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published.