EXCEL 中 怎么提取数值答:定义名称输入 数据 =RIGHT(SUBSTITUTE($A1," ",CHAR(10),LEN($A1)-LEN(SUBSTITUTE($A1," ",))-3),LEN($A1)-FIND(CHAR(10),SUBSTITUTE($A1," ",CHAR(10),LEN($A1)-LEN(SUBSTITUTE($A1," ",))-3)))然后C1输入 =LEFT(数据,FIND(" ",数据)-1)D1输入 =MID(SUBSTITUTE(数据,C1,...