I received an Excel document that has data that looks like the following:
A B C ========================================= 1 |F:\folderName | | | 2 |AAA | | | 3 | AAA1 | None | | 4 | AAA2 | | | 5 | Somedoc.doc| | | 6 |F:\folderName2 | | | 7 |BBB | | | 8 | BBB1 | | | 9 | doc2.doc | | | 10| BBB2 | None | | ... continues ...
The folders can be nested to any depth and the indentations are from using "Format Cells" > "Alignment" > "Indent". Cells with no documents underneath or the word "None" in the second column can be ignored. I need to convert the above list to something usable like:
How can I do this? If I could modify the cells to replace the indentation format with some real spaces I could probably copy the content to a text file and use regular expressions to put the file names together. Is that possible?