excel如何提取前后的英文名?答:比较方便的方法是按空格来分列,大部分都是3个名字的,202行可以特殊处理一下。用公式也可以,前=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))>1,IFERROR(LEFT(A1,FIND(" ",A1)-1),A1),"")后=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))>1,TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ","...
在EXCEL中,如何提取一段英文的每个单词的首字母 例如:DO YOU EVER THI...答:=TRIM(MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99),100),1),1)&MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99),100),2),1)&MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99)...