Question

EXCEL怎样在单元格的数字前批量加同样的字母，如：123122123前加上A

EXCEL怎样在单元格的数字前批量加同样的字母，如：121122123前加上A

Answer 1

以下代码可以实现Sub 按钮1_单击()
Dim X As String
Dim Y As String
Dim Z As String
Dim I As Integer
Dim M As String
Dim N As String
Dim K As String
Dim j As integer'K = InputBox(Prompt:="输入要加的字符！")j= InputBox(Prompt:="输入终止行！") I = 1
For I = 1 To j Z = "A" & I
M = Range(Z)
N = K & M
If Range(Z) <> "" And Range(Z) <> 0 Then
Range(Z).Select
Range(Z) = N
End If
Next I
End Sub

Answer 2

如果你的数据在A2，在B2输入="A"&A2向下填充