excel电子元器件位号C1-C10表示C1,C2,C3,C4,C5,C6,C7,C8,C9,C10

B1输入 =IF(--LEFT(SUBSTITUTE($A$1,"c",""),FIND("-",SUBSTITUTE($A$1,"c",""),1)-1)+ROW(A2)-1>--RIGHT($A$1,LEN(SUBSTITUTE($A$1,"c",""))-FIND("-",SUBSTITUTE($A$1,"c",&