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


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?


You cannot use wildcards with the = operator.

Try this instead:


Answered By – ztiaa

Answer Checked By – Senaida (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published.