portions of data in one cell moved to another

  • Thread starter Thread starter G. Felton
  • Start date Start date
G

G. Felton

I need to sort data in once a series of cells in one
column by the last five numbers. How do I copy those last
five numbers into another column to sort?

Thanks,

G.
 
in case your original data is a number, then try the
following should give you the last 5 numbers of the
contents of the cell A1
=mod(A1, 100000)


In case of text
=right(A1, 5) will give you the last 5 characters of the
contents of cell A1.
 
Back
Top