Posted to microsoft.public.excel.programming

Michael168[_71_] Michael168[_71_] is offline

external usenet poster

Posts: 1

Ascending Order

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

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Place numbers in ascending order	Pavel	Excel Discussion (Misc queries)	2	February 5th 10 03:09 PM
Using vlookup in a table that is not in ascending order	Parks	Excel Discussion (Misc queries)	6	November 21st 07 11:02 PM
How do I # my rows in ascending order.	burgos	Excel Worksheet Functions	1	February 16th 06 07:13 PM
Digits in ascending order ?	toyota58	Excel Worksheet Functions	2	February 3rd 06 06:47 PM
cells in ascending order	mikewild2000[_13_]	Excel Programming	19	January 31st 04 10:54 PM

All times are GMT +1. The time now is 08:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us