copy last five digits in one column

K

Ken Wright

As posted elswhere:-

With your data in A1

=RIGHT(A1,5)

If you need them to be numeric, then:-

=--RIGHT(A1,5)
 
Top