excel中如何在单元格内选择指定文字后的数字(也可能是小数)?答:在B1中输入或复制粘贴下列公式 =TRIM(MID(SUBSTITUTE($A2,CHAR(10),REPT(" ",100)),100*COLUMN(B:B)-99,100))或 =RIGHT(TRIM(MID(SUBSTITUTE($A2,CHAR(10),REPT(" ",100)),100*COLUMN(B:B)-99,100)),LEN(TRIM(MID(SUBSTITUTE($A2,CHAR(10),REPT(" ",100)),100*COLUMN(B:B)-...