混合字符串提取数字 开帖啦，已评分

笨笨四

=MID(A2,MATCH(,MID(A2,ROW(A:A),1)*0,),SUM(LEN(A2),-(MID(A2,ROW(A:A),1)>"9")))

76字符。

hjcotton

LOOKUP("A",RIGHT(LEFT(A2,MATCH(1,-MID(0&A2,ROW($1:141),1))-1),ROW($1:141)))

rlz680926

MID(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),LEN(RIGHT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))))+1),1,LEN(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),LEN(RIGHT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))))+1))-LENB(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),LEN(RIGHT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))))+1))+LEN(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),LEN(RIGHT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))))+1)))

rlz680926

=LEFT(LEFT(MID(A2,I2,LEN(A2)-(LENB(A2)-LEN(A2))),SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))+1),2*LEN(LEFT(MID(A2,I2,LEN(A2)-(LENB(A2)-LEN(A2))),SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))+1))-LENB(LEFT(MID(A2,I2,LEN(A2)-(LENB(A2)-LEN(A2))),SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))+1)))

石岗

在网上找到了一个。不过思路都还没有看明白。研究中。{=MID(A2,MIN(IF(ISNUMBER(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)+0),ROW(INDIRECT("1:"&LEN(A2))))),MAX(IF(ISNUMBER(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)+0),ROW(INDIRECT("1:"&LEN(A2)))))-MIN(IF(ISNUMBER(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)+0),ROW(INDIRECT("1:"&LEN(A2)))))+1}

rlz680926

=IF(ISNUMBER(--RIGHT(LEFTB(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),LEN(A2)),SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))+1),1)),LEFTB(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),LEN(A2)),SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))+1),LEFT(LEFTB(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),LEN(A2)),SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))+1),LEN(LEFTB(MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),LEN(A2)),SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},"")))+1))-1))

JLxiangwei

1. =MID(A2,MATCH(1>1,-MID(A2,ROW(A:A),1)>9,),SUM(N(MID(A2,ROW(A:A),1)&"A"<"A")))

复制代码

先交这个，想到好的再说

雨后的风

数组公式

1. =MID(A2,MATCH(,MID(A2,ROW($1:20),1)*0,),LEN(A2)-SUM(N(MID(A2,ROW($1:20),1)>="A")))

复制代码

rexlei

=MID($A2,MIN(IF(ISNUMBER(MID($A2,ROW(INDIRECT("1:"&LEN($A2))),1)+0),ROW(INDIRECT("1:"&LEN($A2))))),MAX(IF(ISNUMBER(MID($A2,ROW(INDIRECT("1:"&LEN($A2))),1)+0),ROW(INDIRECT("1:"&LEN($A2)))))-MIN(IF(ISNUMBER(MID($A2,ROW(INDIRECT("1:"&LEN($A2))),1)+0),ROW(INDIRECT("1:"&LEN($A2)))))+1)

云龙

1. =MID(A2,MIN(FIND(COLUMN(A:G)-1,A2&1/17)),1+MATCH(1,0*MID(A2,COLUMN(A:Z),1))-MIN(FIND(COLUMN(A:G)-1,A2&1/17)))

复制代码

1. =MID(A2,MIN(FIND(COLUMN(A:G)-1,A2&1/17)),SUM(MATCH({0,1},0*MID(A2,COLUMN(A:Z),1),{0,1})*{-1,1})+1)

复制代码

不得其法，好不容易降到100以内