Forum Discussion

Copper Contributor

Dec 07, 2020

need formula enter in single cell

how to write simple formula in single,each cell got number in column A example 2341 5902 2846 write formula to each single to result smalest to largest in next column B as below 1234 0259 2468

excel

SergeiBaklan

Diamond Contributor

Dec 08, 2020

sunwordelite

As variant

=TEXTJOIN("",1,SORT(MID(A1,SEQUENCE(,LEN(A1)),1),,,1))