RobertBobert
New Member
- Joined
- Aug 19, 2014
- Messages
- 7
Hi, I have a long word document in the form of the sample attached, which is a hierarchical indented list with only two levels. I would like to take this list to Excel
The first entry in the first "column" I would like in cell A1. The next block of text is indented. (It may contain formatting and line breaks). I would like this to be in cell B1.
Then on all the way to the bottom.
I don't mind if the solution is formula based, or VBA based, or anything else.
I don't mind if the formatting in the indented text is affected or lost in the process.
Possible?
Thank you!
Here's a sample:
ps, Here's what the text looks like, and below that, what I would like to see in Excel:
The first entry in the first "column" I would like in cell A1. The next block of text is indented. (It may contain formatting and line breaks). I would like this to be in cell B1.
Then on all the way to the bottom.
I don't mind if the solution is formula based, or VBA based, or anything else.
I don't mind if the formatting in the indented text is affected or lost in the process.
Possible?
Thank you!
Here's a sample:
![1drv.ms](/board/proxy.php?image=https%3A%2F%2Fp.sfx.ms%2Ficons%2Fv2%2FLarge%2FDoc.png&hash=8c94e2481a50f8946d870dbedb1b61ca&return_error=1)
ps, Here's what the text looks like, and below that, what I would like to see in Excel: