Importing Word Content into Excel

littlejilly

Board Regular
Joined
Sep 8, 2011
Messages
165
Hi all,

I have hundreds of word documents. I would like to extract the contents from the word documents and add them into excel with each cell in a single representing a unique word document.

For example, B1 would represent word doc 1
B2 would represent word doc 2
....
...
.
B897 would represent word doc 987.

I do have hundreds of word document making a manual process one that is incredibly inefficient. Any thoughts on how I could execute this?

I can say that each word document does follow consistent formatting but are not set up with any heads.

Thanks!
Jillian
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,204
Office Version
365
Platform
Windows

Forum statistics

Threads
1,089,272
Messages
5,407,313
Members
403,132
Latest member
Black_Mamba_1666

This Week's Hot Topics

Top