Single digit and double digit numbers sequence within a cell

[chintamani.avinash]

Hello,

I have some numbers entered in a single cell. These numbers are separated by space only. Some of these numbers are single digit and some are of double digit. I want to arrange them in proper sequence in that cell only and not in another cell.

For example i have value 22 14 15 2 1 recorded within a cell. I want in the form either 1 2 14 15 22 or 1, 2, 14, 15, 22. No matter whether digits are separated by space or comma.

Please suggest VBA code.
As i am getting these values form customers in single cell only i can not or do not want to get output result in another cell.

For understanding i am giving attachment with this thread.

Thanks a lot in advance.

[Rick Rothstein]

Give this macro a try (it work on whatever cell is selected)...

Please Login or Register  to view this content.

[chintamani.avinash]

Thanks, it is working for single digit number but it does not identify double digit number. It identify double digit number as two single digit number i.e. 15 is considered as 1 and 5. I test this for 5 2 15, expected result should be 2 5 15 but i am getting 15 2 5. Please suggest any solution for this.

[millz]

Try:

Please Login or Register  to view this content.

[chintamani.avinash]

great, its working. Thanks a lot. Thanks for your help.

[Rick Rothstein]

Thanks, it is working for single digit number but it does not identify double digit number. It identify double digit number as two single digit number i.e. 15 is considered as 1 and 5. I test this for 5 2 15, expected result should be 2 5 15 but i am getting 15 2 5. Please suggest any solution for this.

Give this modified version of my original macro a try...

Please Login or Register  to view this content.

[chintamani.avinash]

Thanks a lot for your help.

[chintamani.avinash]

Above codes are working smoothly.

in some cells values are generated by formula. some of them are array. For those cells when i run above code, i get error "Type Mismatch'. Please suggest solution.

[chintamani.avinash]

It works dear but it remove zero from the double digit number who has zero in last e.g. 10 becomes 1, 20 becomes 2.

[chintamani.avinash]

Try:

Please Login or Register  to view this content.

When i tried to use it in the cell where formula exists and value is taken from it shows type mismatch error. Can i sort values in within a cell where formula won't be disturbed and cell will be sorted?

[jindon]

Use like
=SortInCell(A1)

Please Login or Register  to view this content.

[chintamani.avinash]

Use like
=SortInCell(A1)

Please Login or Register  to view this content.

Thanks a lot for your help. Grt work of yours