SEARCH or COUNTIF excel range with INDIRECT


I try to make this formula: =IF(COUNT(SEARCH(MID(D2;ROW(INDIRECT("1:"&LEN(D2)));1);"ABCDEFGHIJKLMNOPQRSTUVWXYZ"))=0;"NO";"OK")

works like this formula:

but its not working when cell starts with no letters.

Image attached


What you are after is probably something like:


For versions prior to ms365, try:


This is build to be auto-remove implicit intersection so the user won’t have to use CSE.

Answered By – JvdV

Answer Checked By – Katrina (AngularFixing Volunteer)

Leave a Reply

Your email address will not be published.