copy last five digits in one column

George · Oct 7, 2003

I need to copy the last five digits in one column to
another column.

G

Ken Wright · Oct 7, 2003

As posted elswhere:-

With your data in A1

=RIGHT(A1,5)

If you need them to be numeric, then:-

=--RIGHT(A1,5)