Sub 单元格前后加字符() Dim i As Integer For i = 1 To ActiveSheet.UsedRange.Rows.Count a = "(" b = ")" c = Cells(i, 1).Value Cells(i, 1).Formula = a + c + b Next End Sub
Sub åå æ ¼ååå å符() Dim i As Integer For i = 1 To ActiveSheet.UsedRange.Rows.Count a = "(" b = ")" c = Cells(i, 1).Value Cells(i, 1).value = a & c & b Next End Sub