I have found the the regexmatch solution for substring: Google Sheets formula for "if contains"
However, why for "*" is not working? I'm trying to make a condition if the name contains "*" it will exclude the stamp duty cost.
As for now, I'm using
What is the explanation why "*" cannot be used?