Copy last characters form one column to another

[George]

I need to copy the last five characters form one column
to another. How do I do this?

G

 

[Ken Wright]

With your data in A1

=RIGHT(A1,5)