{"id":668,"date":"2022-05-10T06:51:27","date_gmt":"2022-05-10T12:51:27","guid":{"rendered":"http:\/\/www.perceptivepetal.com\/wordpress\/?p=668"},"modified":"2022-07-11T12:12:02","modified_gmt":"2022-07-11T18:12:02","slug":"replacing-blanks-with-zeroes-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.perceptivepetal.com\/wordpress\/replacing-blanks-with-zeroes-in-google-sheets\/","title":{"rendered":"Replacing Blanks with Zeroes in Google Sheets"},"content":{"rendered":"<p>Sometime, you might find the need to replace blanks in a Google Sheet with Zeroes.\u00a0 I had that need and\u00a0found this <a href=\"https:\/\/www.statology.org\/google-sheets-replace-blank-cells-with-zero\/#:~:text=To%20do%20so%2C%20click%20the,use%200%20as%20the%20replacement.\" target=\"_blank\" rel=\"noopener\">helpful site<\/a>.\u00a0 As Registrar for our volunteer-led Girl Scout Day Camp, I am responsible for collecting camp fees.\u00a0 I do this through PayPal.\u00a0 We send out Confirmation Emails with all sorts of information including the balance due.\u00a0 The spreadsheet I download from PayPal has blanks in the Amount Due field so I wanted to make sure parents and guardians new that the balance was zero.\u00a0 I used this little trick, and all is good!<\/p>\n<p>The steps are:<\/p>\n<ol>\n<li>Press Ctrl-H to quickly access Find and Replace.<\/li>\n<li><span style=\"font-size: 10pt;\">Type<\/span><strong><span style=\"font-size: 10pt;\"> ^\\s*$\u00a0<\/span><\/strong><span style=\"font-size: 10pt;\"> in the Find box.<\/span><\/li>\n<li><span style=\"font-size: 10pt;\">Type 0 in the Replace box.<\/span><\/li>\n<li><span style=\"font-size: 10pt;\">Check the Match Case and Search Using Regular Expressions boxes.<\/span><\/li>\n<li><span style=\"font-size: 10pt;\">Click the Replace All button.<\/span><\/li>\n<\/ol>\n<pre><code><img decoding=\"async\" loading=\"lazy\" style=\"border: 1px solid black;\" src=\"https:\/\/www.perceptivepetal.com\/wordpress\/wp-content\/uploads\/2022\/05\/replaceblankswithzero-2.png\" alt=\"Screenshot of Replacing Blanks with Zeroes\" width=\"300\" height=\"298\" \/>\n<\/code>\n<\/pre>\n<p><span style=\"font-size: 10pt;\">Now, it is much more clear that my Amount Due is Zero, and not just something that was forgotten.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometime, you might find the need to replace blanks in a Google Sheet with Zeroes.\u00a0 I had that need and\u00a0found this helpful site.\u00a0 As Registrar for our volunteer-led Girl Scout Day Camp, I am responsible for collecting camp fees.\u00a0 I do this through PayPal.\u00a0 We send out Confirmation Emails with all sorts of information including&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[118],"tags":[122,123],"_links":{"self":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts\/668"}],"collection":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/comments?post=668"}],"version-history":[{"count":3,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts\/668\/revisions"}],"predecessor-version":[{"id":673,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts\/668\/revisions\/673"}],"wp:attachment":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/media?parent=668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/categories?post=668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/tags?post=668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}