本帖最后由 蓝色字体 于 2024-3-7 15:31 编辑
那就套公式了,不会简化:
- B2=LEFT(REPLACE(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1,IF(LEFT(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1)="-",1,0),),FIND("-",REPLACE(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1,IF(LEFT(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1)="-",1,0),))-1)
复制代码- C2=SUBSTITUTE(REPLACE(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1,IF(LEFT(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1)="-",1,0),),LEFT(REPLACE(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1,IF(LEFT(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1)="-",1,0),),FIND("-",REPLACE(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1,IF(LEFT(SUBSTITUTE(IFNA(FORMULATEXT(B5),B5),"=",),1)="-",1,0),))),)
复制代码
|