How do you check a cell for a special character?

[basbrian]

Hi guys,
how do I write an If statement to check to see if the cell contains a wingding squareroot symbol (alt 251) in the cell?

 

[pgc01]

Hi
Welcome to the board

Wingding has no square root symbol, but has a Tick symbol (like the ones you use on a checkbox) that looks a bit like the square root symbol. That's symbol 252 in Wingdings.

To check if the symbol exists in the cell use:

=ISNUMBER(SEARCH(A1,CHAR(252)))

Remark: this checks if character 252 exists, independently of the font.

 

[basbrian]

Thanks

 

[pgc01]

Sorry, I just realised that the parameters are not in the correct order.

It should be:

=ISNUMBER(SEARCH(CHAR(252),A1))

so that it finds the character inside the text value in A1.

If the character 252 is the only character in A1, then you can simply use:

=A1=CHAR(252)