|
- Sub TEST()
- ARR = Sheet2.Range("A1:A" & Sheet2.Range("A65536").End(3).Row)
- N = UBound(ARR)
- ReDim BRR(1 To UBound(ARR), 1 To 1)
- T = 0
- For I = 1 To UBound(ARR)
- T = T + 1
- BRR(T, 1) = LTrim(ARR(I, 1))
- If Mid(ARR(I, 1), 4, 1) = "、" Then
- GoTo 20
- Else
- 10 E = Right(ARR(I, 1), 1)
- If Len(ARR(I, 1)) <> 1 And E = " " Then
- E = Mid(ARR(I, 1), Len(ARR(I, 1)) - 1, 1)
- End If
- If InStr(",。!”)::,", E) Then
- GoTo 20
- Else
- I = I + 1
- BRR(T, 1) = BRR(T, 1) & LTrim(ARR(I, 1))
- GoTo 10
- End If
- End If
- 20 Next
- Sheet3.Range("A1").Resize(T, 1) = BRR
- End Sub
复制代码 |
|