EXCEL里,一段英文单词里,如何去掉其中几个英文单词EXCEL里,一段英文单词,如:WOMEN'S 95% COTTON 5%ELASTANE SHIRT,用什么公式可以把最前面一个英文单词“WOMEN'S" 和最后一个英文单词”SHIRT
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/05 15:59:28
![EXCEL里,一段英文单词里,如何去掉其中几个英文单词EXCEL里,一段英文单词,如:WOMEN'S 95% COTTON 5%ELASTANE SHIRT,用什么公式可以把最前面一个英文单词“WOMEN'S" 和最后一个英文单词”SHIRT](/uploads/image/z/14619107-11-7.jpg?t=EXCEL%E9%87%8C%2C%E4%B8%80%E6%AE%B5%E8%8B%B1%E6%96%87%E5%8D%95%E8%AF%8D%E9%87%8C%2C%E5%A6%82%E4%BD%95%E5%8E%BB%E6%8E%89%E5%85%B6%E4%B8%AD%E5%87%A0%E4%B8%AA%E8%8B%B1%E6%96%87%E5%8D%95%E8%AF%8DEXCEL%E9%87%8C%2C%E4%B8%80%E6%AE%B5%E8%8B%B1%E6%96%87%E5%8D%95%E8%AF%8D%2C%E5%A6%82%EF%BC%9AWOMEN%26%2339%3BS+95%25+COTTON+5%25ELASTANE+SHIRT%2C%E7%94%A8%E4%BB%80%E4%B9%88%E5%85%AC%E5%BC%8F%E5%8F%AF%E4%BB%A5%E6%8A%8A%E6%9C%80%E5%89%8D%E9%9D%A2%E4%B8%80%E4%B8%AA%E8%8B%B1%E6%96%87%E5%8D%95%E8%AF%8D%E2%80%9CWOMEN%26%2339%3BS%26quot%3B+%E5%92%8C%E6%9C%80%E5%90%8E%E4%B8%80%E4%B8%AA%E8%8B%B1%E6%96%87%E5%8D%95%E8%AF%8D%E2%80%9DSHIRT)
EXCEL里,一段英文单词里,如何去掉其中几个英文单词EXCEL里,一段英文单词,如:WOMEN'S 95% COTTON 5%ELASTANE SHIRT,用什么公式可以把最前面一个英文单词“WOMEN'S" 和最后一个英文单词”SHIRT
EXCEL里,一段英文单词里,如何去掉其中几个英文单词
EXCEL里,一段英文单词,如:WOMEN'S 95% COTTON 5%ELASTANE SHIRT,
用什么公式可以把最前面一个英文单词“WOMEN'S" 和最后一个英文单词”SHIRT“去掉,只留中间的成分描述”95% COTTON 5%ELASTANE“
用什么公式可以把中间的成分描述”95% COTTON 5%ELASTANE'去掉,只留最前面最前面一个英文单词“WOMEN'S" 和最后一个英文单词”SHIRT“ ,变成WOMEN'S SHIRT.
根据各热心网友回答,补充一下问题,我不仅仅是要解决这一段英文单词,而是要批量处理一系列这样的英文段落,最后面的一个英文单词长度不一(有5个字母的,有4个字母的).这个比较麻烦
WOMEN'S 100% VISCOSE SHIRT
WOMEN'S 98% COTTON 2%ELASTANE PANT
WOMEN'S 100% VISCOSE SKIRT
EXCEL里,一段英文单词里,如何去掉其中几个英文单词EXCEL里,一段英文单词,如:WOMEN'S 95% COTTON 5%ELASTANE SHIRT,用什么公式可以把最前面一个英文单词“WOMEN'S" 和最后一个英文单词”SHIRT
参照下面的公式:
=MID(TRIM(A1),FIND(" ",TRIM(A1))+1,FIND("々",SUBSTITUTE(TRIM(A1)," ","々",LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))))-FIND(" ",TRIM(A1)))
如果头尾没有空格,公式可以简化为:
=MID(A1,FIND(" ",A1)+1,FIND("々",SUBSTITUTE(A1," ","々",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-FIND(" ",A1))