|
发表于 2014-4-13 09:25
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr, i&, s&
- arr = Range("u4:u" & Range("u65536").End(xlUp).Row)
- ReDim brr(1 To 3, 1 To Columns.Count)
- For i = 1 To UBound(arr)
- If arr(i, 1) <> "" Then
- s = s + 1
- brr(1, s) = arr(i, 1)
- brr(2, s) = Left$(arr(i, 1), 1)
- brr(3, s) = Mid$(arr(i, 1), 2)
- End If
- Next
- [1:3].NumberFormatLocal = "@"
- Range("a1").Resize(3, s) = brr
- Range("a1").Resize(3, s).Sort Key1:=[a2], Key2:=[a3], Header:=xlGuess, Orientation:=xlLeftToRight
- Range("a2").Resize(2, s).ClearContents
- End Sub
复制代码 |
|