excel组合型字符分类
如分类类型
a代表字母,1代表数字,意思是所有这种格式类型的组合字符改字怎么分出来
h2570qqcom
sz7565423962
Quan3021214
lo9160k
u5974163net
rxY15102280
me2739ooikz
比如me2739ooikz的格式就是aa1111aaaaa
我要在几十万的数据里面抓出aa1111aaaaa这种字母和数字组合的字符
求公式
从几十万条数据里抓数?
建议你还是用VBA吧!
请看图:
代码:
Sub 筛选()
Range("A2").Select
js1 = 2
js3 = 2
Do While Len(Cells(js1, 1)) <> 0
js2 = 1
zfc = ""
Do While js2 <= Len(Cells(js1, 1))
zf = Mid(Cells(js1, 1), js2, 1)
zfc2 = zfc2 & zf
If zf >= "0" And zf <= "9" Then zf = "1" Else zf = "a"
zfc = zfc & zf
js2 = js2 + 1
Loop
If zfc = "aa1111aaaaa" Then
Cells(js3, 3) = Cells(js1, 1)
js3 = js3 + 1
End If
js1 = js1 + 1
Loop
End Sub
排序、筛选都可以
下一篇:电脑配制cpu两核能換成四核吗?