I have a Excel file that within one column tells me all the files we have on our LAN. I am only interested in extracting out the folder names from each cell value and placing the result into multiple columns. How do I within Excel VBA using the InStr or other method to evaluate the cell with the file information and extract all the individual folder names and place the result in individual columns (1st Path 2nd Path, 3rd Path,etc.) The folder structure does not go beyond 5 deep.
Result I need
Row 1st Path 2nd Path 3rd Path 4th Path
1 Employees Midwest 2010 -
2 Employees West 2010 -
3 Employees East 2010 Suspended