EXCEL 提取特定符号前后数字公式

B1公式：u201cu3002trim(MID(SUBSTITUTE($A1,"*","REPT(" & " " ,LEN($A1)))u201du201cu3002u3002右拉下拉范围：u201c$A1:$A1+10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" u201d