M
mi20chelle02
I am trying to sort my colum by the last two digits of the number in each cell.
EX:
50201.1001
50201.1002
50201.1003
50201.2001
50201.2002
50201.2003
50201.3001
50201.3002
50201.3003
I want to sort by the last two digist of 01,02,03 of my column. Does anyone
have any idea how to do this. Or if it is even possible. If you do please
can you explain to me step by step what I will have to do to accomplish this
task.
Thanks for your help.
EX:
50201.1001
50201.1002
50201.1003
50201.2001
50201.2002
50201.2003
50201.3001
50201.3002
50201.3003
I want to sort by the last two digist of 01,02,03 of my column. Does anyone
have any idea how to do this. Or if it is even possible. If you do please
can you explain to me step by step what I will have to do to accomplish this
task.
Thanks for your help.