Excel提取文本字符串中最小的数值来看看

Excel提取文本字符串中最小的数值?
=MIN(--TEXT(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"×","m"),"*","m"),"=","m"),"m",REPT(" ",15)),{1,16,31},15),"[<>];;0;\9\e\9"))
【Excel提取文本字符串中最小的数值来看看】
下面一个参考 , 不怕长:
=MIN(--CHOOSE(2-COUNT(FIND("=",C2)),-LOOKUP(,-MID(C2,FIND("=",C2)+1,ROW($1:$22))),MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"×","*"),"mm",),"*",REPT(" ",15)),{1,16,31},15)))

    推荐阅读