Sub test()
Dim regx As Object
Dim i As Integer
Dim j As Integer
Dim arr
arr = Sheets("原表").UsedRange
Set regx = CreateObject("vbscript.regexp")
regx.Global = True '上面大神的语句里加上这句就行
regx.Pattern = "\d+"
For i = 1 To UBound(arr)
For j = 1 To UBound(arr, 2)
Sheets("期望表").Cells(i, j) = regx.Replace(arr(i, j), "空")
Next
Next
End Sub
Sub a()
Dim Rng As Range, Arr(1 To 3) As String, i%
With CreateObject("vbscript.regexp")
.Pattern = "\d+"
For Each Rng In Range("A1").CurrentRegion
i = i + 1
Arr(i) = .Replace(Rng, "空")
Next
End With
[E1].Resize(1, 3) = Arr
End Sub
Sub test()
Dim regx As Object
Dim i As Integer
Dim j As Integer
Dim arr
arr = Sheets("原表").UsedRange
Set regx = CreateObject("vbscript.regexp")
regx.Global = True '上面大神的语句里加上这句就行
regx.Pattern = "\d+"
For i = 1 To UBound(arr)
For j = 1 To UBound(arr, 2)
Sheets("期望表").Cells(i, j) = regx.Replace(arr(i, j), "空")
Next
Next
End Sub