在EXCEL中,如何提取一段英文的每个单词的首字母 例如:DO YOU EVER THINK ABOUT ME 提取出:
收藏:
0
点赞数:
0
评论数:
0
1个回答

=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),100),3),1)&MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99),100),4),1)&MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99),100),5),1)&MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99),100),6),1)&MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99),100),7),1)&MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99),100),8),1)&MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99),100),9),1)&MID(A1,SMALL(IF(MID(" "&A1&" ",ROW($1:$99),1)=" ",ROW($1:$99),100),10),1))

公式以CTRL+SHIFT+回车结束.

此公式最多可处理10个单词.

点赞数:
0
评论数:
0
关注公众号
一起学习,一起涨知识