|
- Sub px()
- Dim ar(1 To 99), arr, i&, j%, cf
- arr = Sheets("jh").[a1].CurrentRegion.Resize(, 2)
- For i = 1 To UBound(arr)
- cf = Split(arr(i, 1), " ")
- For j = 0 To UBound(cf)
- ar(cf(j)) = cf(j)
- Next
- arr(i, 2) = Application.Trim(Join(ar))
- Erase ar
- Next
- Sheets("jh").Columns("c:c").Clear
- Sheets("jh").[c1].Resize(UBound(arr), 1) = Application.Index(arr, , 2)
- Erase arr
- End Sub
复制代码 改到99,把所有2位数到概括到
|
|