想请教各位大佬，产品代码很长，就想提取中间部分货号出来，数据很多，有快速提取.

精致的猪猪女孩

如图，想要把长代码里边的货号提取出来，但是长代码的长度位置不一致，请教如何快速的提取想要的数据。谢谢

xlllw203

1. =CONCAT(TEXT(MID(TEXT(-1%,SUBSTITUTE(SUBSTITUTE(C2,".",";"),"-",";")),ROW(1:99),1),"0;;0;"))

复制代码

流浪星星

=-LOOKUP(1,-RIGHT(MID(A1,1,FIND("-",A1)-1),ROW($1:$9)))

xlllw203

1. =TRIM(MID(SUBSTITUTE(C2,"-",REPT(" ",99)),MATCH(,0*MID(LEFT(C2,FIND("-",C2)-1),ROW(4:99),1),)+3,99))

复制代码

发现还有以字母结尾的。。。用这个

quqiyuan

=MID(A18,MATCH(,MID(MID(A18,4,LEN(A18)),ROW($1:$99),1)*0,)+3,FIND("-",A18)-MATCH(,MID(MID(A18,4,LEN(A18)),ROW($1:$99),1)*0,)-3)
数据单元格在A18

xfbanxian

=MID(SUBSTITUTE(LEFT(A27,FIND("-",A27)-1),"01.",""),MIN(IFERROR(FIND(ROW($1:$10)-1,SUBSTITUTE(LEFT(A27,FIND("-",A27)-1),"01.","")),"")),99)

leepoison

=MID(A1, FIND(" ", A1) + 1, FIND("-", A1) - FIND(" ", A1) - 1)