=--LEFT(SUBSTITUTE(MID(F1,FIND("+",SUBSTITUTE(F1," ","+",3))+1,50),"约",""),FIND("颗",SUBSTITUTE(MID(F1,FIND("+",SUBSTITUTE(F1," ","+",3))+1,50),"约",""))-1),下拉
追问不行哦,你有QQ么,我加你
追答44 72 48 510(验证信息:excel),把问题作为内容(邮件主题一定要包含“excel”,本人以此为依据辨别非垃圾邮件,以免误删)、excel样表文件(把现状和目标效果表示出来)作为附件发来看下 [email protected]
本回答被提问者采纳