Excel:根据整个单元格值进行替换 [英] Excel: replace based on whole cell value

问题描述

我想用空白替换所有为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.

例如

ex1

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.

ex2

3)之后，您可以点击全部替换，您应该就可以开始了！

3) After that you can just hit Replace all and you should be good to go!

ex3

这篇关于Excel:根据整个单元格值进行替换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！