问题描述
我想用空白替换所有为0的单元格.通常，我会使用Excel查找&替换功能(Ctrl + R):
I would love to replace all cells that is 0 with blank. Normally I would use the Excel find & replace function (Ctrl + R):
Find what: 0
Replace with:
但是它将替换所有单元格中的所有0，因此60将变为0.
But it would replace all 0s in all cells, so that 60 will become 0.
是否有一种方法只能在单元格确实为0时替换0?
Is there a way to only replace the 0s if the cell is indeed 0?
非常感谢
推荐答案
查找与获取"内置了一个功能.如果整个单元格值与您的参数匹配，则替换仅将编辑一个单元格.
There is a function built into Find & Replace that will only edit a cell if the entire cell value matches your parameter.
例如
1)在我的起始数据中，您只想替换值= 0的单元格
1) There is my starting data where you only want to replace the cells where the value = 0
2)打开查找并替换，然后选择仅查找整个单元格"选项.请记住，我在Mac上拍摄了这些屏幕截图.我相信在PC上，您必须点击选项"按钮才能打开一个对话框，您可以在其中进行选择.
2) Open up your find and replace and select the "Find entire cells only" option. Keep in mind that I took these screenshots on a Mac. On a PC I believe you will have to hit the Option button to open a dialogue box where you can make the selection.
3)之后，您可以点击全部替换，您应该就可以开始了！
3) After that you can just hit Replace all and you should be good to go!
这篇关于Excel:根据整个单元格值进行替换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！