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

--
Regards
Frank Kabel
Frankfurt, Germany


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 in
ascending order 234.

What formula should be in cell D1?

Thanks
Michael


---
Message posted from http://www.ExcelForum.com/