Posted to microsoft.public.excel.misc

Caroline

external usenet poster

Posts: 183

Sorting 1, 2, 10, 20 to 1, 10, 2, 20

I am trying to sort a list of articlenumbers, example:
1, 2, 10, 22, 202.

I want to sort it like: 1, 10, 2, 202, 22.

Can anyone tell me how to do that?

Thank you in advance!!

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
sorting	Michaela	Excel Worksheet Functions	1	November 20th 06 06:34 AM
Sorting: Sorting by the First Character	dzuy	Excel Discussion (Misc queries)	2	June 22nd 06 08:27 PM
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . .	agc1234	Excel Discussion (Misc queries)	6	May 26th 05 08:02 PM
sorting	gwl	Excel Discussion (Misc queries)	0	January 27th 05 06:27 PM
help on sorting	Ray	Excel Discussion (Misc queries)	1	January 24th 05 11:03 PM

All times are GMT +1. The time now is 05:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us