To work around this issue, clear the zero-length string from the cell. To do this, select the cell, click Edit, and then click Clear All.

In addition, you can also check whether a cell contains a zero-length string by using the LEN function. For example, if the cell you are checking is A1, the formula will be =OR(Len(A1)=0, Isblank(A1)).

Let me know if this gave you some insights.

Regards,
Jerry