Hi,
I would like to be able to delimit or trim data by the number of occurrences of a special character. I want to be able to extract the file path but not the file names.
this is what I want it to do:
\home drive\Data\Web stuff\test.xls -> \home drive\Data\Web stuff
\home drive\Data\Web stuff\links\test.xls -> \home drive\Data\Web stuff\links
\home drive\Data\readme.txt -> \home drive\Data
I can use LEN to figure out how many "\" there are, but I'm not sure how to cut off the file name e.g.(test.xls) after the correct number of "\"s. Thanks for any help!
Chris
Excel 2010
I would like to be able to delimit or trim data by the number of occurrences of a special character. I want to be able to extract the file path but not the file names.
this is what I want it to do:
\home drive\Data\Web stuff\test.xls -> \home drive\Data\Web stuff
\home drive\Data\Web stuff\links\test.xls -> \home drive\Data\Web stuff\links
\home drive\Data\readme.txt -> \home drive\Data
I can use LEN to figure out how many "\" there are, but I'm not sure how to cut off the file name e.g.(test.xls) after the correct number of "\"s. Thanks for any help!
Chris
Excel 2010