加载中…Excel VBA 单元格添加字符
(2013-07-12 04:31:30)| 分类： VBA |
Sub add()
For I = 1 To 100
s = Cells(I, 2).Value
Cells(I, 2).Value = "0" & s '第二列每个单元格字符串前添加“0”
Next
End Sub
For I = 1 To 100
s = Cells(I, 2).Value
Cells(I, 2).Value = "0" & s '第二列每个单元格字符串前添加“0”
Next
End Sub
喜欢
0
赠金笔