如题所述
B2公式下拉:
=IF(A2="","",-LOOKUP(,-LEFT(A2,{1;2})))
C2公式右拉下拉:
=IF($A2="","",-LOOKUP(,-LEFT(MID($A2,SUMPRODUCT(LEN($B2:B2))+COLUMN(B1),2),{1;2})))