- Sub 替换成软回车()
- Dim arr, i%, k&
- arr = Range("b5:b" & Range("b65536").End(3).Row)
- For i = 1 To UBound(arr)
- For k = Len(arr(i, 1)) To 2 Step -1
- If Mid(arr(i, 1), k, 1) Like "[a-z,A-Z]" Then
- arr(i, 1) = Replace(arr(i, 1), Mid(arr(i, 1), k, 1), Chr(10) & Mid(arr(i, 1), k, 1))
- End If
- Next
- Next
- Range("b5").Resize(UBound(arr)) = arr
- End Sub
复制代码 |