笨方法,按原表次序依次如下:
=MID(C3,SEARCH("于",C3)+1,10)
=MID(C3,SEARCH("车号为",C3)+3,7)
=LEFT(MID(C3,SEARCH("净重",$C3)+4,6),SEARCH("吨",MID(C3,SEARCH("净重",$C3)+4,6))-1)
=IFERROR(LEFT(MID($C3,SEARCH("总扣款",$C3)+3,10),SEARCH("元",MID($C3,SEARCH("总扣款",$C3)+3,10))-1),"")
=IFERROR(LEFT(MID($C3,SEARCH("总共扣重",$C3)+4,10),SEARCH("吨",MID($C3,SEARCH("总共扣重",$C3)+4,10))-1),"")
=IFERROR(F3-H3,F3)
=LEFT(MID(MID($C3,SEARCH("净重为",$C3)+4,20),SEARCH(",",MID($C3,SEARCH("净重为",$C3)+4,20))+1,10),SMALL(IFERROR(SEARCH(ROW($1:$10)-1,MID(MID($C3,SEARCH("净重为",$C3)+4,20),SEARCH(",",MID($C3,SEARCH("净重为",$C3)+4,20))+1,10)),100),1)-1),此项需要数组三键
|