hi all
i have random numbers in a cell that need to sort in a numeric 1-100 form
eg. 1 4 8 20 37 56 9 81 12 11 23 40(all this in one cell) there thousands of cell in a row need to be rearrange
and the when this done i want to sort them in a 1 2 3 -100 form aswell
eg. 1 2 3 4 5 6 10 11 12 13 14
1 2 3 4 5 6 10 11 12 13 15
1 2 3 4 5 6 10 11 12 13 16
at the moment excel sort it as smallest to largest, end up like:
1 10 ..........
1 11........
1 2...........
kind regards
Bookmarks