Why does GSheet's "find" not find my blank cells even though ISBLANK() finds them?-CodePudding

Home > front end > Why does GSheet's "find" not find my blank cells even though ISBLANK() finds them?

Why does GSheet's "find" not find my blank cells even though ISBLANK() finds them?

Time：11-27

I have the following problem: When I type "^\s*$" into GSheet's "find" it does not find my blank cells even though ISBLANK() finds them. I need to find and replace the blank cells with "NA". Help would be greatly appreciated!

This is an excerpt of my table:

Page link：https//www.codepudding.com/frontend/206745.html

Prev:Google sheets max cells limits and mitigations

Next:How do I use different data in the same class based on the View Controller that uses it in Objective

Tags：

google-sheets

spreadsheet

find-replace

Links：
CodePudding