[已解决]函数求助

Excel120

注:公式要求没有带精品字的,就截取空格后两位+最后两位,有带精品两位的则取空格后三位+最后两位(中间空格不定长度),谢谢!

最佳答案

月排行榜 / 总排行榜

tkgg93

2017-6-4 14:03

1. =MID(A2,FIND(" ",A2)+LEN(A2)-LEN(SUBSTITUTE(A2," ",)),2+ISNUMBER(FIND("精品",A2)))&RIGHT(A2,2)

复制代码

跳转到最佳答案楼层

qqyyh

=IF(ISNUMBER(FIND("精品",A2)),MID(A2,FIND("@",SUBSTITUTE(A2,"  ","@")),5)&RIGHT(A2,2),MID(A2,FIND("@",SUBSTITUTE(A2,"  ","@")),4)&RIGHT(A2,2))

tkgg93

1. =MID(A2,FIND(" ",A2)+LEN(A2)-LEN(SUBSTITUTE(A2," ",)),2+ISNUMBER(FIND("精品",A2)))&RIGHT(A2,2)

复制代码

Excel120

qqyyh 发表于 2017-6-4 11:58
=IF(ISNUMBER(FIND("精品",A2)),MID(A2,FIND("@",SUBSTITUTE(A2,"  ","@")),5)&RIGHT(A2,2),MID(A2,FIND("@ ...

谢谢！你的公式没有考虑空格不定长度问题

Excel120

tkgg93 发表于 2017-6-4 14:03

谢谢！