Sort number small to big

[sunwordelite]

Hello sir need formula for using non vba .example image attach .I need to sort number smallest to largest in cell A2 to B2
4digit in single cell '5 digit and 6 digit in...

 

[eirikdaude]

A formula like

=CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));1))&CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));2))&CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));3))&CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));4))

should do it for a 4-digit number. I dunno if there is any way to generalize it for an arbitrary amount of digits.

As you see it is the formula

CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1))

concatenated several times. You need to have as many digits inside the curly braces as there are digits in the number, and you need to increase the last argument in the function by one for every concatenation.

I found the formula here.

 

[Fluff]

@sunwordelite
What version of Excel are you using?
Please update your account details to show this, as it affects what functions you can use.

 

[sunwordelite]

@sunwordelite
What version of Excel are you using?
Please update your account details to show this, as it affects what functions you can use.

Sir using Excel 2013

 

[Fluff]

Ok, how about

+Fluff v2.xlsm
	B	C
10	987321	123789
11	40968321	01234689
12	406	046
Master

Cell Formulas
Range	Formula
C10:C12	C10	=TEXT(SUM(SMALL(--MID(B10,ROW(INDIRECT("1:"&LEN(B10))),1),ROW(INDIRECT("1:"&LEN(B10))))*10^(LEN(B10)-ROW(INDIRECT("1:"&LEN(B10))))),REPT("0",LEN(B10)))
Press CTRL+SHIFT+ENTER to enter array formulas.

Please don't forget to update your account details & then scroll down & click Save.

 

[sunwordelite]

A formula like

=CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));1))&CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));2))&CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));3))&CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));4))

should do it for a 4-digit number. I dunno if there is any way to generalize it for an arbitrary amount of digits.

View attachment 27516


As you see it is the formula

CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1))

concatenated several times. You need to have as many digits inside the curly braces as there are digits in the number, and you need to increase the last argument in the function by one for every concatenation.

I found the formula here.

Sir I copy this formula got error

 

[sunwordelite]

Wait si

Ok, how about

+Fluff v2.xlsm
	B	C
10	987321	123789
11	40968321	01234689
12	406	046
Master

Cell Formulas
Range	Formula
C10:C12	C10	=TEXT(SUM(SMALL(--MID(B10,ROW(INDIRECT("1:"&LEN(B10))),1),ROW(INDIRECT("1:"&LEN(B10))))*10^(LEN(B10)-ROW(INDIRECT("1:"&LEN(B10))))),REPT("0",LEN(B10)))
Press CTRL+SHIFT+ENTER to enter array formulas.

Please don't forget to update your account details & then scroll down & click Save.

Sir I try first thanks for reply

 

[sunwordelite]

A formula like

=CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));1))&CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));2))&CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));3))&CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1));4))

should do it for a 4-digit number. I dunno if there is any way to generalize it for an arbitrary amount of digits.

View attachment 27516


As you see it is the formula

CHAR(SMALL(CODE(MID(B3;{1;2;3;4};1))

concatenated several times. You need to have as many digits inside the curly braces as there are digits in the number, and you need to increase the last argument in the function by one for every concatenation.

I found the formula here.

sir thank you very much formula work well for 3d
.thank you

 

[sunwordelite]

Wait si

Sir I try first thanks for reply

sir sorry late reply.i try to copy the formula not work

 

[Fluff]

What language version of Excel are you using?
Also what do you normally use as separators in your formulae?