Copy last characters form one column to another

George · Oct 7, 2003

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

G

Ken Wright · Oct 7, 2003

With your data in A1

=RIGHT(A1,5)