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))...
第21,22,23,24,25,26,27,28,29,30,31的英语怎么说答:第21:twenty-first /21st;第22:twenty-second/22nd;第23:twenty-third/23rd;第24:twenty-fourth/24th;第25:twenty-fifth/25th;第26:twenty-sixth/26th;第27:twenty-seventh/27th;第28:twenty-eighth/28th;第29:twenty-ninth/29th;第30:thirtieth/30th;第31:thirty-first/31th。