Sub Del()
Dim cell As Object

    For Each cell In Range("A2:A10")
        If Not IsEmpty(cell) Then
        cell.Value = Right(cell, Len(cell) - 123)
        Columns("A").HorizontalAlignment = xlCenter
    End If

    Next cell