|
- Sub 替换()
- Dim Arr1, Arr11()
- Dim Row1, I, S, SZ1, SZ2, SZ
- Row1 = Range("A65536").End(xlUp).Row
- Arr1 = Range("A1:A" & Row1)
- ReDim Arr11(1 To UBound(Arr1), 1 To 1)
- For I = 1 To UBound(Arr1)
- S = Arr1(I, 1)
- SZ1 = InStr(Replace(S, "/", "#", , 5), "/")
- SZ2 = InStr(SZ1, S, ".")
- SZ = Mid(S, SZ1 + 1, SZ2 - SZ1 - 1)
- Arr11(I, 1) = Left(S, 27) & "Showabcown.asp?UrljlID=100&SoftID=" & SZ
- Next I
- Range("B1").Resize(UBound(Arr1), 1) = Arr11
- End Sub
复制代码
301596-VBA-替换字符-如何用宏将A列内容变为B列.rar
(9.21 KB, 下载次数: 3)
|
|