Sub text_cut()
Dim i As Long, col As Long, text As String, q, lr
q = 4 ' количество символов
col = 1 ' номер столбца
lr = Cells(Rows.Count, col).End(xlUp).Row
For i = 1 To lr
text = Cells(i, col).Value
Cells(i, col).Value = Left(text, q)
Next i
End
End Sub