Excel ::
Text :: 1,3,5,2,9,5,11
Result ::
1,2,3,5,5,9,11 |
Formula ::
TEXTJOIN(",",1,SORT(MID(SUBSTITUTE(A1,",",REPT(" ",100)),SEQUENCE(LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1,,1,100),100)+0))
Excel ::
Text :: 1,3,5,2,9,5,11
Result ::
1,2,3,5,5,9,11 |
Formula ::
TEXTJOIN(",",1,SORT(MID(SUBSTITUTE(A1,",",REPT(" ",100)),SEQUENCE(LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1,,1,100),100)+0))
Excel :: Text :: 1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula :: TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...