Find blank cell and put in "0"

[Akiko]

Hi there,

I’m creating daily sales flow but sometimes when we don’t get any sales, we have some blank cells.
I would like to know how to put in 0 (zero) to those blank cells.

Thanks, Akiko

[andrew]

Hey @Akiko! If the cells are blank, you could use the Find and replace step. The step would look like this (leave the value blank and choose whichever column(s) you’d like to apply this to):

[Akiko]

Hi Andrew, Thank you so much for your help. I could fix it!

[brian]

Adding on to Andrew’s answer, if the above does not work, you can also use a Regex step set up like this: