need formula enter in single cell

Copper Contributor

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

2 Replies

@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

 

 

@sunwordelite 

As variant

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