need formula enter in single cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1963376%22%20slang%3D%22en-US%22%3Eneed%20formula%20enter%20in%20single%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1963376%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20to%20write%20simple%20formula%20in%20single%2Ceach%20cell%20got%20number%20in%20column%20A%20example%202341%205902%202846%20write%20formula%20to%20each%20single%20to%20result%20smalest%20to%20largest%20in%20next%20column%20B%20as%20below%201234%200259%202468%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1963376%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1964332%22%20slang%3D%22en-US%22%3ERe%3A%20need%20formula%20enter%20in%20single%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1964332%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893649%22%20target%3D%22_blank%22%3E%40sunwordelite%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeck%20this%20tutorials%20on%20the%20link%2C%20it%20is%20using%20VBA%20code%20to%20do%20so%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F1870-excel-sort-numbers-within-cell.html%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1966875%22%20slang%3D%22en-US%22%3ERe%3A%20need%20formula%20enter%20in%20single%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1966875%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893649%22%20target%3D%22_blank%22%3E%40sunwordelite%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DTEXTJOIN(%22%22%2C1%2CSORT(MID(A1%2CSEQUENCE(%2CLEN(A1))%2C1)%2C%2C%2C1))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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))