Ascending Order

M

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
 
F

Frank Kabel

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

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 *
 
A

AA2e72E

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
 
Top