你好 用正则貌似也行的
Sub djk()
Dim rng, k%, i%, arr
Set regx = CreateObject("vbscript.regexp")
With regx
.Global = True
.Pattern = "\S"
For Each rng In [a1:a2]
Set mat = .Execute(rng)
k = mat.Count
ReDim arr(1 To k)
For i = k To 1 Step -1
j = j + 1
arr(j) = mat.Item(i - 1)
Next
Cells(rng.Row, "c") = Join(arr, "")
j = 0
Next
End With
End Sub