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