1
1
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:
F:\folderName\AAA\AAA2\Somedoc.doc
F:\folderName2\BBB\BBB1\doc2.doc
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?
Do you want a VBA or worksheet-function solution? – Lance Roberts – 2010-11-10T21:42:07.670
Whatever gets the job done. This is just a one-time thing. – adam0101 – 2010-11-10T21:54:20.607