I am trying to profile about 100,000 documents based off of their file paths. I want to be able to tell the document type and document sub type just based on the document path. For example Y:\Clients\J\Jamison, Andrew\Tax\1040.Tax - Jamison, Andrew - 2010 - Revision.Pdf the document type would be Taxes and the document sub type would be W2. I am trying to profile about 100,000 documents so I don't really want to do this by hand. I am looking for an excel function that I might have missed or possibly a formula that would help me out. Any help is greatly appreciated. Thanks
Bookmarks