1. 替换
SUBSTITUTE(字符串, 原字符串, 新字符串)
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(L2,"镇",""),"乡",""),"办事处","")
2. 判断一个单元格是否在另外一列中存在
=IF(COUNTIF(A:A,C1)>0,"有","无")
=IF(COUNTIF(目标列,判断列首个单元格)>0,"是","否")
excel数据处理，公式
原文：http://www.cnblogs.com/warling/p/7119869.html
