Substitute empty cells with the value"0"

Maty · September 21, 2011 8:58AM

My goal is to substitute empty cell with a “0” value. I’ve found the way, however I think that it could work much easier if this function was integrated within operations block. A “delete empty data” block already exists, I could imagine substitute "0" for "nulls" command somewhere there.

daniel · September 21, 2011 9:11AM

I've found that the Search/Replace will work for this and you can put this into the operations, also lets you decide which character to have it replace with and can be done against multiple or selected fields/columns

chris · September 21, 2011 9:14AM

Hi,

Thanks for the question/comment.

Leave the "Search for" blank and check "Match entire cell". Enter the value you want to use to replace empty values (in this example "0") in the "Replace with" box.

Welcome!

Categories

Ideas Parade