Excel中计算某字符串在单元格中的数量
约 120 字小于 1 分钟
2025-07-23
=(LEN(C2)-LEN(SUBSTITUTE(C2,"<p>","")))/3=(LEN(C2)-LEN(SUBSTITUTE(C2,"<h3>","")))/4=(LEN(C2)-LEN(SUBSTITUTE(C2,"<p>","")))/3-(LEN(C2)-LEN(SUBSTITUTE(C2,"</p>","")))/4=(LEN(C2)-LEN(SUBSTITUTE(C2,"<h3>","")))/4-(LEN(C2)-LEN(SUBSTITUTE(C2,"</h3>","")))/5=(LEN(C2)-LEN(SUBSTITUTE(C2,"<h4>","")))/4-(LEN(C2)-LEN(SUBSTITUTE(C2,"</h4>","")))/5这两个可以计算内容中标签对是否完整，结果为0就是完整的，不为0就是有问题的