Press Alt + F11 to open a Microsoft Visual Basic for Application window.Ģ. If you are familiar to VBA, you can use below VBA code to convert zero to blank cell.ġ. Click the Close button to exit the Find and Replace dialog. And you can see the zero cells have been replaced with blank.ĥ. Then click Replace All, and a dialog pops out tell you how many cells have been replaced. In the Find and Replace dialog, click Replace tab, and type 0 into Find what text box, a space into Replace with dialog, then click Options to expand the dialog and check Match entire cell contents. Press Ctrl + F to display Find and Replace dialog.Ģ. Have you ever tried to convert the zero cells to blank cells in Excel? Now I tell you some quick ways to batch convert the zero cell to blank cells in Excel.Ĭonvert zero to blank by Find and Replace functionĬonvert zero to blank with Kutools for Excelįind and Replace function is very useful in Excel, you can use it to find all zero cells first, and then replace it with blank.ġ. How to convert zero to blank in selected range in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |