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