Try

=RIGHT(A1,6)

Or select the entire column, and go to Data - then use Text to Columns.

From there, select Delimited, and then manually select the spot you want to chop off the numbers. When you click finish, it will automatically split the data in the column in the spot you selected.