GreyEyedWolf
New Member
- Joined
- Jul 26, 2014
- Messages
- 14
Hello, I was wondering if anyone had a good method for taking cells with file paths and removing the file names from them?
For example if I had the following path
C:\TEST\WORD.DOC I would want the cell to read C:\TEST to just contain the folder.
I have a long list of file paths with names and want to extract only the paths. Text to columns ends up being more work because some of the folder structures are very deep, so I would like an easier solution.
Thanks
For example if I had the following path
C:\TEST\WORD.DOC I would want the cell to read C:\TEST to just contain the folder.
I have a long list of file paths with names and want to extract only the paths. Text to columns ends up being more work because some of the folder structures are very deep, so I would like an easier solution.
Thanks