Excel高级函数应用实例完整版-精品

文字与数字分离函数用法

怎样以、号为分割点取数值

检测项目细菌总数、致病菌、铅

标准值<100、<3、<0.1

检测值50、2、0.05

红字区的三个字段下数值引用蓝字区的数值以、号为分割点，用函数怎么做！

检测项目字段引用b1单元格

标准值项目字段引用b2单元格

检测值字段引用b3单元格

三个字段都以b1b2b3单元格中、号为分割点

UM(LEN(C4)-LEN(SUBSTITUTE(C4,{"0","1","2","3","4","5","6","7","8","9"," "},""))))) =SUBSTITUTE(C6,D6,"")

=LEFT(C30,FIND("、",C30,1)-1)

=MID(C29,FIND("、",C29,1)+1,FIND("、",SUBSTITUTE(C29,"、","",1),1)-FIND("、",C29,1)) =MID(C30,FIND("、",SUBSTITUTE(C30,"、","",1),1)+2,LEN(C30))

分割点，用函数怎么做！