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