|
本帖最后由 老司机带带我 于 2016-12-20 12:41 编辑
转换成数值根据前面那位老师的代码多个循环就行了,空格已加!- Sub 提取数据X()
- Dim r, match, arr, i As Integer, j As Integer, brr, x As Integer, str$
- Set r = CreateObject("vbscript.regexp")
- arr = Sheet3.Range("B2:AA12")
- x = 1
- r.Pattern = "[\u4e00-\u9fa5]+\s*[\u4e00-\u9fa5]*"
- r.Global = False
- With Sheet2
- For i = 1 To UBound(arr, 2) Step 2
- For j = 2 To UBound(arr)
- If arr(j, i) <> "" Then
- x = x + 1
- str = r.Execute(arr(j, i))(0)
- If Len(str) = 2 Then
- .Cells(x, 1) = Mid(str, 1, 1) & " " & Right(str, 1)
- Else
- .Cells(x, 1) = str
- End If
- .Cells(x, 2) = arr(1, i)
- brr = Split(arr(j, i + 1), "、")
- lColumn = 2
- For u = 0 To UBound(brr)
- lColumn = lColumn + 1
- .Cells(x, lColumn) = brr(u)
- Next
- Else
- Exit For
- End If
- Next
- Next
- End With
- End Sub
复制代码
|
|