Skip to content

Google script: substitute blank cells by “x”

by manuel on October 30th, 2014

Today I had a big spreadsheet with quite a few missing values, which I wanted to substitue by “x”. So I decided to write my first google script!

I’ts pretty straight forward: in your open spreadsheet, go to Tools > Script Editor and put in the following code:

Close and reopen your spreadsheat. You will see a menu “My Scripts” after “Help”, just click on the function and wait for it to finish!

From → Blog, Useful stuff

No comments yet

Leave a Reply

Note: XHTML is allowed. Your email address will never be published.

Subscribe to this comment feed via RSS