Rank order a sequence of numbers WITHIN A CELL

[xmbwd]

I have a series of numbers inside a cell that are not in order.
For example:

[33, 22, 2, 9, 1, 45].

Is there any way (other than simply retyping the numbers) to automatically reorder the numbers so that they are listed sequentially??

The result would look like this (again, inside a single cell):

[1, 2, 9, 22, 33, 45]

Although these numbers are in one cell, I have the same issue with thousands of cells, so retyping is not an option.

Thanks so much for any help.

 

[xmbwd]

Norie -- you totally nailed it. That works perfectly. Thanks so much for the edits. And thanks again to Jindon for getting us started.

In answer to your question, its just a numbered series that was formerly associated with words. I did a global replace to match with a code of numbers. But of course the numbers were out of sequence, hence the need for the code.

Thanks again. So helpful

 

[Norie]

xmbwd

Glad to see you got it sorted.

The question about the sort was actually for Jindon.

There are various different methods of sorting using code. eg Bubble Sort

I'm not sure which method Jindon is implementing but I think I've seen it somewhere before.

Knowing me it probably is a Bubble Sort, and I'm just not recognizing it as such.

 

[jindon]

Jindon

Hope you don't mind me altering your code.

By the way what type of sort is that?

I seem to vaguely recognise it from university, but that was a long time ago.

Thanks for the modification and it is based on "QuickSort" algorithm.