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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by file/directory like explorer
Have you tried to use text to columns (Data - Text to Columns) to split out
the directory path into seperate cells. You can then sort the individual columns that contain the path to achieve what you want... -- HTH... Jim Thomlinson "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by file/directory like explorer
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by file/directory like explorer
I understand what you mean but I have several lists which need to be sorted
this way on their own. I wanted to avoind having to do manual sorting with the sheer volume of information I have! Any other ideas? "Jim Thomlinson" wrote: Have you tried to use text to columns (Data - Text to Columns) to split out the directory path into seperate cells. You can then sort the individual columns that contain the path to achieve what you want... -- HTH... Jim Thomlinson "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by file/directory like explorer
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! Any other ideas? "Jim Thomlinson" wrote: Have you tried to use text to columns (Data - Text to Columns) to split out the directory path into seperate cells. You can then sort the individual columns that contain the path to achieve what you want... -- HTH... Jim Thomlinson "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by file/directory like explorer
Record a macro when you do it once and reexecute that macro for the other
worksheets. NikiB wrote: I understand what you mean but I have several lists which need to be sorted this way on their own. I wanted to avoind having to do manual sorting with the sheer volume of information I have! Any other ideas? "Jim Thomlinson" wrote: Have you tried to use text to columns (Data - Text to Columns) to split out the directory path into seperate cells. You can then sort the individual columns that contain the path to achieve what you want... -- HTH... Jim Thomlinson "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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by file/directory like explorer
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |