| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sort alphanumeric data
I have data with mix number of digits and I like to sort them. Somehow, the
normal sorting process give me a not so desired result. Can anyone help? A10 B100 A2 AA1 AD200 A1 The result I am looking for is: A1 A2 A10 B2 B100 AD200 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort alphanumeric | Excel Discussion (Misc queries) | |||
| macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
| Unable to sort data in excel with cells containing if & hlookup | Excel Worksheet Functions | |||
| Sort data from 1 work sheet into another | Excel Worksheet Functions | |||
| Alphanumeric Sort | Excel Discussion (Misc queries) | |||
Threaded Mode
