[已解决]有请老师帮忙，有附件有说明

cqzcs

说明及要求：在A列中会不规则出现⊙ ① ② ③ ④ ⑤ ⑥ ⑦ ⑧ ⑨字符，要求在B列写入公式，当A列出现上述任一字符时以0来表示，没有字符时则直接等于A列的值。目前我在B列的公式只能写到8个字符，因为A列的字符超过10个以上，故请老师帮忙另写公式。谢谢！！！

最佳答案

月排行榜 / 总排行榜

chensir

2013-12-10 11:44

=IF(COUNT(FIND({"⊙","①","②","③","④","⑤","⑥","⑦","⑧","⑨"},A2)),0,A2)

跳转到最佳答案楼层

chensir

=IF(COUNT(FIND({"⊙","①","②","③","④","⑤","⑥","⑦","⑧","⑨"},A2)),0,A2)