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

2 Replies

SergeiBaklan
Diamond Contributor
Dec 08, 2020
sunwordelite

As variant

=TEXTJOIN("",1,SORT(MID(A1,SEQUENCE(,LEN(A1)),1),,,1))
Jihad Al-Jarady
MCT
Dec 07, 2020
sunwordelite

check this tutorials on the link, it is using VBA code to do so
https://www.extendoffice.com/documents/excel/1870-excel-sort-numbers-within-cell.html