Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported a report from a disk catalog program to help find duplicate files. I have tried to sort this data using sort and filter commands. I want to sort by filename extention. I.E. *.com , *.exe , *.jpg ... There are too many to list in a pivot table. how can this be done from *.aaa to *.zzz ?
 
Assuming every file in your list has a standard three
letter file extension, you could split the file name into
two columns. If your names start in cell A1, in B1 put

=Right(a1,3)

Copy this formula down the whole list, then sort the whole
range by column B, then Column A.

Pete
-----Original Message-----
I have imported a report from a disk catalog program to
Click to expand...
help find duplicate files. I have tried to sort this data
using sort and filter commands. I want to sort by filename
extention. I.E. *.com , *.exe , *.jpg ... There are too
many to list in a pivot table. how can this be done from
*.aaa to *.zzz ?
 
Thank you for the tip. You Inadvertently answered another question for me, How to split fields. Is there a good book that could help me learn these tricks? It looks like you are using a form of basic.
 
Back
Top