|
本帖最后由 bipl607 于 2013-5-26 00:12 编辑
请教:如何用宏将A列内容变为B列内容,谢谢!
A | B | http://abcd123.com.cn/cvbn/Showabcown.asp?SoftID=13853 | http://abcd123.com.cn/cvbn/Showabcown.asp?UrljlID=100&SoftID=13853 | http://abcd123.com.cn/asdfr/Showabcown.asp?SoftID=138514 | http://abcd123.com.cn/asdfr/Showabcown.asp?UrljlID=100&SoftID=138514 | http://abcd123.com.cn/qazxswed/Showabcown.asp?SoftID=13855 | http://abcd123.com.cn/qazxswed/Showabcown.asp?UrljlID=100&SoftID=13855 | http://abcd123.com.cn/cvbn/Showabcown.asp?SoftID=13856 | http://abcd123.com.cn/cvbn/Showabcown.asp?UrljlID=100&SoftID=13856 |
原来的宏是这样的,现在不能用了,应该怎么改,谢谢!
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
本帖最后由 那么的帅 于 2013-5-26 00:47 编辑
bipl607 发表于 2013-5-26 00:19
刚才附件不能上传,现在可以了,谢谢! - 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)
- S1 = Left(S, InStr(S, "?"))
- S2 = Right(S, Len(S) - InStr(S, "?"))
- Arr11(I, 1) = S1 & "UrljlID=100&" & S2
- Next I
- Range("B1").Resize(UBound(Arr1), 1) = Arr11
- End Sub
复制代码
301599-VBA-替换字符-如何用宏将A列内容变为B列.rar
(9.26 KB, 下载次数: 7)
|
|