Ascending Order

[Michael168]

Can someone show me the formula to solve my problem?

Cell A1=3
Cell B1=4
Cell C1=2

in cell D1=a1&b1&c1 which give me 342 but I like it to show i
ascending order 234.

What formula should be in cell D1?

Thanks
Michae

 

[Frank Kabel]

Hi
one way (if you only have these three cells):
=MIN(A1:C1) & LARGE(A1:C1,2) & MAX(A1:C1)

 

[A.W.J. Ales]

Michel,

Try =SMALL(A1:C1,1)&SMALL(A1:C1,2)&SMALL(A1:C1,3)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Guest]

Tr
=Small(A1:C1,1)*100+ Small(A1:C1,2)*10 + Small(A1:C1,3)

Assumes that cells A1,B1 & C1 contain a single digit

Small(A1:C1,1) & Small(A1:C1,2) & Small(A1:C1,3) ' this gives you the correct sequence as tex