Sub process()
On Error Resume Next
Dim ws As Worksheet
Dim lastRow As Integer
Dim arr(), str1 As String, str2 As String
Dim regex As Object
Dim matches As Object
Set ws = ThisWorkbook.Sheets("Sheet1")
Set regex = CreateObject("VBScript.RegExp")
regex.Global = True
regex.IgnoreCase = True
regex.Pattern = "[\u4e00-\u9fa5\d]+"
With ws
lastRow = .UsedRange.Rows.Count
.Range("C2:C" & lastRow).ClearContents
arr = ws.Range(Cells(2, 2), Cells(lastRow, 3)).Value
For i = 1 To UBound(arr)
str1 = arr(i, 1)
Set matches = regex.Execute(str1)
For j = 0 To matches.Count - 1
str2 = str2 & matches(j) & " "
Next
str2 = Left(str2, Len(str2) - 1) '去掉尾部多余空格
arr(i, 2) = Left(str1, InStr(str1, " ")) & str2
str2 = ""
Next
.Range("B2").Resize(UBound(arr), 2) = arr
End With
End Sub