怎么组合几个函数公式

XFX477_H087_A01_BOM_V1.2_20180122(88X9C(2V8)=LEFT(B3,FIND("@",SUBSTITUTE(B3,"_","@",LEN(B3)-LEN(SUBSTITUTE(B3,"_",))))-1)=SUBSTITUTE(B3,"_BOM","")=SUBSTITUTE(B3,"_","-")用这三个公式把上面那段字符提取出这个XFX477-H087-A01-V1.2我想把这三个公式组合成一个，按顺序计算应该怎么组合 ？ 我来答分享举报1个回答#热议# OPPO Reno6系列发布会有哪些值得看的点？百度网友7b0c7d72018-02-10 · TA获得超过3680个赞关注=SUBSTITUTE(SUBSTITUTE(LEFT(B3,FIND("@",SUBSTITUTE(B3,"_","@",LEN(B3)-LEN(SUBSTITUTE(B3,"_",))))-1),"_BOM",),"_","-")或=SUBSTITUTE(SUBSTITUTE(LEFT(B3,LOOKUP(1,0/(MID(B3,ROW(1:99),1)="_"),ROW(1:99))-1),"_BOM",),"_","-")本回答被网友采纳