| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by file/directory like explorer
Hi,
I have a heap of files with their full directory paths and would like to sort them in a tree structure. For example, sort the file names out first then by the directory names. So where I have the following in my list: Candle/Candle.txt Corn/Corn.txt Delivery/Delivery.txt Eggs.txt Ham.txt Open/Open.txt Sandwich/Sandwich.txt Service/Service.txt i would like them to be sorted like this: Eggs.txt Ham.txt Candle/Candle.txt Corn/Corn.txt Delivery/Delivery.txt Open/Open.txt Sandwich/Sandwich.txt Service/Service.txt Any help appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Directory and File Detection | Excel Discussion (Misc queries) | |||
| File directory structure reorg | Links and Linking in Excel | |||
| file save error: the file or directory cannot be created | Excel Discussion (Misc queries) | |||
| Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
| Double Click .xls file in Explorer opens Excel but no file | Setting up and Configuration of Excel | |||
Threaded Mode
