若前一单元格内包含某个字,在当前单元格内返还指定字符的操作方法如下:
一、如下图的表格中A列有几个名字,这时要在B列中查找A列单元格中是否包含“某”这个字,如果有,则返还“有”,如果无,则返还“无”,这时点击B1单元格,然后点击公式栏。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3119313b07eca80d42aaa99812397dda14483a5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、在B1单元格的公式栏中输入公式=IF(ISERROR(FIND("某",A1)),"无","有") 。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/810a19d8bc3eb135cbe824c5b61ea8d3fd1f44a5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
三、然后点击公式栏上的“√”,最后下拉填充公式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7fd5266d0160924830b3165c40735fae6cd34a5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
四、最终效果如下图,这时在B列中能够检测出A列单元格是否包含“某”这个字(注意,公式中的“有”和“无”二字可以更换成自己所需的文字或特定符号,但注意保留双引号)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/aa64034f78f0f736eed0df7f1a55b319ebc413a5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)