recognizing special characters outside a certain ASCII range in excel does not always work
<p>I recently asked a question (<a href="https://stackoverflow.com/questions/37675402/check-if-a-text-string-contains-special-characters-in-excel/37676706?noredirect=1#comment62832149_37676706">Check if a text string contains special characters in excel</a>) on how to check if cells contain ASCII codes outside a certain range. </p>

<p>Since, I use the following formula:</p>

<p>=IF(SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT("1:"&amp;LEN(A1))),1))>=32)*(CODE(MID(A1,ROW(INDIRECT("1:"&amp;LEN(A1))),1))&lt;=126))=LEN(A1),"OK","Not OK")</p>

<p>where I check if cell A1 contains any special characters outside the 32-126 ASCII range.</p>

<p>And I thought this was working fine. However I noticed that this formula doesn't pick up all special characters. E.g. ≥, β,... are not getting recognized. The formula returns 'ok' even when it shouldn't... </p>

<p>Does anybody now what causes this? for other special characters, this formula works fine.</p>