excel电子元器件位号C1-C10表示C1,C2,C3,C4,C5,C6,C7,C8,C9,C10_百度...
发布网友
发布时间：2024-04-18 07:43
共1个回答
热心网友
时间：2024-04-18 13:23
=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",""),1)),"","c"&(--LEFT(SUBSTITUTE($A$1,"c",""),FIND("-",SUBSTITUTE($A$1,"c",""),1)-1)+ROW(A2)-1))
下拉
实际使用可以吧c替换为实际名称
