View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Sort by file/directory like explorer

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