小中大括弧裡字符串 取出 (1372)

單一小括號C2=MID(LEFT(B2,FIND(")",B2)-1),FIND("(",B2)+1,9)

小中大括號 均可C2=MID(LEFT(B2,-LOOKUP(1,-FIND({")","]","}"},B2))-1),1-LOOKUP(1,-FIND({"(","[","{"},B2)),9)



留言