Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Only what I wrote in the followup in that other branch.
NikiB wrote: thanks, I understand what you mean but I have many lists that i wish to sort in their own right and would prefer if there was no manual intervention! Previous response had already suggested I use that method :) Any other ideas? "Dave Peterson" wrote: I would use data|text to columns, delimited by the backslash and separate each piece of the file name into separate columns. Then I could sort by the columns I want (maybe multiple times if the number of levels is larger than 3). NikiB wrote: 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 -- Dave Peterson -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |