Getting a single cell to list its (4) digits in chronological order

[jimblimm]

in A1 have the number

4251

The cell b1 should display 1245

currently i have to split the number into 4 cells

c1=left(a1,1) d1=mid(a1,2,1) e1=mid(a1,3,1) f1=right(a1,1)

then i have to concatenate small to large.. its gotta be a simpler way

 

[mikerickson]

I think this will do what you want
=SUBSTITUTE(SUMPRODUCT(ISNUMBER(FIND(COLUMN(A1:J1),A1))*COLUMN(A1:J1)*(10^(9-COLUMN(A1:J1)))), "0", "")

 

[jimblimm]

STUPID QUESTION,,, but what does the A1:J1 do

 

[Ingolf]

I think this will do what you want
=SUBSTITUTE(SUMPRODUCT(ISNUMBER(FIND(COLUMN(A1:J1),A1))*COLUMN(A1:J1)*(10^(9-COLUMN(A1:J1)))), "0", "")

This formula works if the number has no "zero" inside and have not two or more identical number inside. See example below:
55103 --> 1351

 

[shg]

ADVERTISEMENT

Another way:

=TEXT(SUMPRODUCT(LARGE(--MID(E11,{1,2,3,4},1), {1,2,3,4}),{1,10,100,1000}), "0000")

 

[jimblimm]

the formula works on a number with all different digits but what if i had numbers like

0112
1111
1122

its dropping some of the digits

 

[Ingolf]

the formula works on a number with all different digits but what if i had numbers like

0112 This is not a number
1111 Here nothing to move because the number is in format you want
1122 Here nothing to move because the number is in format you want

its dropping some of the digits

shg formula is working for your example.

 

[jimblimm]

thanx a mill