Import text from word document into excel

[macropod]

Hi mayseed,

Try the attached. Do note there is a limit to what can be achieved with what you're working with. If your documents differ significantly from what you've posted, much of the code I've written could be invalidated - and coding around the difficulties might not be practical/possible.

One thing to note is that I've assumed the doctor's name & title at the end (which I assume you don't want) always span two paragraphs. They get deleted during processing (the changes aren't saved) so that they don't get included with the extracted data.

As for the data in the multiple paragraphs:
for example.. the technique field: then the statements (4 in the sample file) need to be inserted into 4 different fields in the table.

I don't think it's practical to do that, as you'll never know how many columns might be involved. For now, the code just puts them all in the one cell.