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