Select the Entire Data in which you want to replace Zeros with blank cells.Ģ. Replace Zeros With Blank in Excelįollow the steps below to replace zeros with blanks in Excel.ġ. With this understanding, let us go ahead and take a look at the steps to replace zeros with blank, dash or text field in Excel. If you replace zeros with Dash (-) or a Text in Excel, you may sometimes encounter errors, if cells with Dash or Text Field are referenced in certain formulas.