Sort numeric values VBA

Question

I have the info. can be in a list, merely in columns and rows, or really anywhere.

I've entered data such as 10, 1010, 11, 111, 2, 201, 3210, 300100, etc. with a maximum of six integers. I want the data to be sorted.

10 1010 11 111 2 201 300100 3210

And not like

2 10 11 111 201 1010 3210 300100

Any stylish approach to this I'm able to make it work with filters, so I just need some code, but I'm at a loss.

If I put a "." or another character in between each number, I can make it work with filters. After that, just add a filter and order by. not even attempted any codes.

Answer 1

Try:

The formula in B1:

=SORTBY(A1:A8,LEFT(A1:A8&"00000",6))