To convert all blank cells in a range within a Google Sheet: - Select the range and then use `Ctrl + F` to open the Find box. - Click the three dot menu to open the Find/Replace dialog box, - Use `^\s* to represent blank values in the Find box and check **Search using regular expressions**. - Input `#N/A` in the Replace with box. - Click **Replace all**.