问题描述
因此，我希望Excel在特定列中查找并替换所有以"R"开头的单词，并将其全部更改为"Resolved".似乎是一个简单的替换或替换，但是我似乎无法仅使用以"R"开头的单词来使用它.谢谢！
So I want Excel to find and replace all words starting with "R" in a certain column and change them all to "Resolved". It seems like a simple substitute or replace, but I can't seem to get it to work with only words starting with "R". Thanks!
推荐答案
您要的是公式".这通常是您输入单元格中的内容.如果是这样，那么如果您在A列中有单词列表，则可以将以下公式放在单元格B1中:
You are asking for a "formula". That is usually something you enter into a cell. If that is the case, then if you have the list of words in the A column, you could put the following formula in cell B1:
=IF(LEFT(A1, 1)="R", "Resolved", A1)
这将测试A1中的第一个字母-如果它是A，它将在B1中放入"Resolved"，否则它将复制A1.
This will test for the first letter in A1 - if it is A, it will put "Resolved" in B1, otherwise it copies A1.
现在，您可以向下复制此方程式(双击单元格右下角的小方块)，以隐藏列A，然后完成工作.或者，您可以将B列的所有内容都复制，然后将B粘贴特殊...仅值"粘贴到A上，然后删除A.
Now you could copy this equation down (double click the little square in the bottom right hand corner of the cell) hide column A, and the job is done. Or you could copy all of column B, and "paste special... Values only" B onto A, then delete A.
还有其他方法.从您的问题中不清楚您到底在追求什么.
There are other ways too. It was not clear from your question what you were really after.
这篇关于excel公式来替换或仅填充以某个字母开头的文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！