This will replace all the blank cells in the range with the value 0 in Google Sheets. Enable ‘Search using regular expressions’.ħ. Enter 0 in the ‘Replace with’ field (or any other value like a hyphen).Ħ. In the ‘Find’ field, enter the above regular expression to match blank cells.ĥ. I have already given the shortcuts (Mac/Windows) above.Ĥ. Go to the menu Edit and click on ‘Find and Replace’. I mean, we can get back the original format later.ģ. Don’t worry about losing the formatting of values. Go to the Format menu and select Number > Plain text because the above reg expression won’t work in a number column. In this method, you may want to use the following regular expression which matches blank cells in Google Sheets. The above ‘cons’ are not applicable to this method. However, one thing that I constantly need to do and couldn’t in Docs. I love how easy it is to use and to collaborate with others. Some organizations I work with use Google Docs. Want to find and replace several blank cells, whether it’s in a column or multiple columns, with zeros in Google Sheets? Then use the Edit menu, Find and Replace option. Google Docs is handy to use especially for collaborations, but its inability to find and replace extra carriage returns or newlines is a pain. Regex in Find and Replace to Replace Blank Cells with Zeros in Google Sheets The formulas would be converted to values. It will fill the blank space with 0 values and keep the other values like numbers, texts or dates as it is.Ĭons: You will lose any formulas in the column. Right-click on cell B2 and choose Paste Special > Paste values only.

Find and replace in mac for google