Is it possible to find a particular sentence in Excel and replace it with the contents of another cell? I can't use the find and replace function as every cell is different.
是否可以在Excel中找到特定的句子并将其替换为另一个单元格的内容?我不能使用查找和替换功能,因为每个单元格都不同。
For example:
A B
Canon iP7240 iPad Air
So now I'd like to search "Canon iP7240 - A4 Printer" and it must automatically change to what is written in Cell B.
所以现在我想搜索“佳能iP7240 - A4打印机”,它必须自动更改为单元格B中的内容。
1 个解决方案
#1
0
When you are in the search and replace dialog, on the "replace with" just write the =+the desired cell. For example: replace with: =A2. Hope this is what you where asking for.
当您在搜索和替换对话框中时,在“替换为”上只需写入= +所需的单元格。例如:替换为:= A2。希望这是你所要求的。
#1
0
When you are in the search and replace dialog, on the "replace with" just write the =+the desired cell. For example: replace with: =A2. Hope this is what you where asking for.
当您在搜索和替换对话框中时,在“替换为”上只需写入= +所需的单元格。例如:替换为:= A2。希望这是你所要求的。