In this post we will learn about how to find asterisk in excel.We may find some special character and wildcard character embedded into our data especially if the data source is some third party database or portal.
One of the special character is asterisk and we will see below how to find and replace asterisk in excel.
Let’s see how we could write a formula to find if there is an “*” (asterisk) character present in a cell in excel.
Microsoft Excel uses the tilde (~) as a marker to indicate that the next character is a literal.
We will write a formula that will let us find asterisk availability in a cell in excel.
We have written a simple formula using SEARCH, if and IFERROR formula in excel.
Enter the formula below in cell B2 to find if an asterisk is present in the cell or not.
=IFERROR(IF(SEARCH(“~*”, A2), “true”, “false”),”false”)
As you could see we have got the desired result.
Hope this helped.