Sub test()
Dim A, i
Sheets(1).Select
A = Range("a1:d" & Range("b65536").End(xlUp).Row)
For i = 1 To UBound(A)
If InStr(A(i, 1), "编") = 0 Then A(i, 1) = A(i, 2) & A(i, 3) & A(i, 4)
Next i
[a1].Resize(i - 1, 4) = A
End Sub
Sub hb()
With Application
.ScreenUpdating = False
arr = Sheet1.UsedRange
For i = 1 To UBound(arr)
If arr(i, 1) <> "编 码" Then
arr(i, 1) = arr(i, 2) & arr(i, 3) & arr(i, 4)
End If
Next i
[a2].Resize(UBound(arr), UBound(arr, 2)) = arr
.ScreenUpdating = True
End With
End Sub
Sub test()
Dim A, i
Sheets(1).Select
A = Range("a1:d" & Range("b65536").End(xlUp).Row)
For i = 1 To UBound(A)
If InStr(A(i, 1), "编") = 0 Then A(i, 1) = A(i, 2) & A(i, 3) & A(i, 4)
Next i
[a1].Resize(i - 1, 4) = A
End Sub