'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?

functiongoogle-sheetsexpressionwildcard


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Wildcard matching in Java

Traefik Docker with wildcard domain

incompatible types: Myclass cannot be converted to CAP#1 where CAP#1 is a fresh type-variable:CAP#1 extends Myclass from capture of ? extends Myclass

Java: How to implement wildcard matching?

Java string matching with wildcards

Elasticsearch wildcard query in Java - find all matching fields and replace

Regex to match code with fixed country code and variable wildcard usage

Use Wildcards in Replace Function in combination with 2D Array Values

Is it possible to use a wildcard to disable audio devices?

How to build multi-origin Trusted Web Activity with a wildcard for subdomains

Python - if ... then with multiple wildcards

How to write a function that only accepts one enum variant as input?

How to write a function that only accepts one enum variant as input?

How to write a function that only accepts one enum variant as input?

How to write a function that only accepts one enum variant as input?