|
发表于 2012-11-19 11:53
|
显示全部楼层
本楼为最佳答案
Sub 按钮1_单击()
Dim a, i, j
a = Range("a1").CurrentRegion
For i = 1 To UBound(a)
For j = 1 To UBound(a, 2)
If InStr(a(i, j), "$") Then a(i, j) = Split(a(i, j), "$")(1)
Next j
Next
[a1].Resize(i - 1, j - 1) = a
End Sub
一键清除无用信息附件2.rar
(8.43 KB, 下载次数: 9)
|
评分
-
查看全部评分
|