Can I show only the last 8 characters in a column using formatting?

[fredqwerty]

I am copying codes into a column on excel but only want the last 8 characters showing.
Can I do this using format cells or conditional formatting?
I know I can use =RIGHT(A1,8) to show last 8 characters in another cell but am copying across rows of data at a time so don't really have the space.

[fredqwerty]

How is this mark solved when no-one has answered it?