亚州 发表于 2022-1-20 22:43:53

就是这样的结果，第二行的那种，公式怎么设置呢

暴躁的团子 发表于 2022-1-27 14:22:48

还以为第一个是3731W，第二个371W，第四个3163W

维修翻新各种红木家具 发表于 2022-1-29 12:26:40

http://127.0.0.1/data/attachment/forum/202202/08/175045rbsy2r07babsrwny.png

陈其爱 发表于 2022-2-1 02:00:13

直接上代码了吗？公式处理不了吗

港澳行货代购 发表于 2022-2-2 13:11:58

Sub FilterW()
r = Cells(Rows.Count, 1).End(xlUp).Row
ar = Range("A2").Resize(r, 2)
ReDim br(1 To r, 1 To 3)
For i = 1 To r - 1
ss = Filter(Split(ar(i, 1), "-"), "W")
n = UBound(ss)
If n > -1 Then
    br(i, 1) = ss(0)
    br(i, 3) = ss(n)
End If
If n > 0 Then br(i, 2) = ss(1)
Next
Range("B2").Resize(r, 3) = br
End Sub

巫法舞天 发表于 2022-2-4 21:45:11

=IFERROR(FILTERXML("<a><b>"&SUBSTITUTE($A1,"-","</b><b>")&"</b></a>","//bla!st()")&"]"),"")

猪槑槑 发表于 2022-2-7 03:34:10

学艺不精，凑活着用
B2输入=IFERROR(TRIM(MID(SUBSTITUTE($A2,"-",REPT(" ",99)),SEARCHB("W",SUBSTITUTE($A2,"-",REPT(" ",99)),1)-98,99)),"")
C2输入=IFERROR(TRIM(MID(SUBSTITUTE($A2,"-",REPT(" ",99)),SEARCHB("W",SUBSTITUTE($A2,"-",REPT(" ",99)),SEARCHB("W",SUBSTITUTE($A2,"-",REPT(" ",99)),1)+1)-98,99)),"")
D2输入=IFERROR(TRIM(MID(SUBSTITUTE($A2,"-",REPT(" ",99)),SEARCH("W",SUBSTITUTE($A2,"-",REPT(" ",99)),(SEARCHB("W",SUBSTITUTE($A2,"-",REPT(" ",99)),SEARCHB("W",SUBSTITUTE($A2,"-",REPT(" ",99)),1)+1)+1))-98,99)),"")

建立 发表于 2022-2-7 11:46:17

371KK01-371W-378M
以这个来说事吧
第一个是371W第二个为空   最后一个为371W是这规则吗

隐形者 发表于 2022-2-8 02:35:12

还以为第一个是3731W，第二个371W，第四个3163W

东尼大木 发表于 2022-2-12 16:04:12

页: 1 2 [3] 4
查看完整版本: 如何提取一窜数字里面想要的符号