提特定符号前的数值 (9054)

 

  D2{=LEFT(B2,MIN(IFERROR(FIND({"/","\"},B2),99)-1))

另解 (依數據 OK ,B2後面有 "\" 有誤)=LEFT(B2,-LOOKUP(,-FIND({"/","\"},B2))-1)

另解=LEFT(B2,MIN(FIND({"/","\"},B2&"/\")-1))