EXCEL里,一段英文单词里,如何去掉其中几个英文单词答:如果数据在A1 B1=REPLACE(A1,SMALL(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=" ",ROW(INDIRECT("1:"&LEN(A1))),4^8),1)-1,MAX(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=" ",ROW(INDIRECT("1:"&LEN(A1))),0))-SMALL(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1))...