Sort numbers within a Cell from Large to Small (Ascending & Decending)

Dear Forum Members,

Can you please provide formula to sort numbers within a cell from Large to Small.
For instance, i have a number in cell A2=46921 and after sorting, it should be A2=96421.

thank you in advance

use this formula BUT after you copy it, Edit the cell (F2) and hit Ctl + Shift + Enter (this will put in the 'curly brackets' { & } in the cell...this is used for ARRAY formulas like this one) =TEXT(SUM(LARGE(--MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),ROW(INDIRECT("1:"&LEN(A2))))*10^(LEN(A2)-ROW(INDIRECT("1:"&LEN(A2))))),REPT("0",LEN(A2)))

Try this array formula (Ctrl+Shift+Enter);

Please Login or Register  to view this content.

You may need to change ";" with "," depending on your regional settings.

Originally Posted by queuesef

use this formula BUT after you copy it, Edit the cell (F2) and hit Ctl + Shift + Enter (this will put in the 'curly brackets' { & } in the cell...this is used for ARRAY formulas like this one) =TEXT(SUM(LARGE(--MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),ROW(INDIRECT("1:"&LEN(A2))))*10^(LEN(A2)-ROW(INDIRECT("1:"&LEN(A2))))),REPT("0",LEN(A2)))

Thanks a lot for support

Originally Posted by Haluk

Try this array formula (Ctrl+Shift+Enter);

Please Login or Register  to view this content.

You may need to change ";" with "," depending on your regional settings.

thanks a lot for support

You're welcome...