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:
ps, Here's what the text looks like, and below that, what I would like to see in Excel: