Find Asterisk In Excel

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.

Capture




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”)

Capture

As you could see we have got the desired result.




Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply