Check If A Cell Contains Question Mark In Excel

Data exported from some portal or non standard source often has non printable characters or the characters or symbol that is converted to question mark(“?”) or some other symbol.

Below example could also be used to check if the URL contains a variable and their value or not as they are separated by a question mark.

Let’s see how we could write a formula to find if there is a “?” (Question mark) character is 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 the asterisk is available in a cell or not.




Capture

I 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