portions of data in one cell moved to another

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.
 
A

Akshay Bakhai

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cell data entering slow! 0
Cannot sort a table containing text 5
Offset, Match Questiond 7
question on sorting 0
copy data while skipping a predetermined number of cells 5
Autonumber field in Excel that behaves the same as Access 0
Need Help with a VBA subroutine 0

Top