Annieonline
New member
- Joined
- Feb 6, 2013
- Messages
- 3
- Reaction score
- 0
- Points
- 0
I am trying to help a colleague handle information that currently populates a 732 page PDF document, so my first thought was Excel. I saved the document into Excel format, but (a) roughly 50% of this transferred information is useless and (b) what I do want to work with dumps into one column more than 50,000 rows down. :scared: I have gone back to the original PDF and saved it as a Word document, so that I can edit out the useless information. This will leave me with the names and addresses that I am wanting to pull, but they all go into rows in the first column. Is there any way I can break them into 3 columns for every three rows? (Name, address, city - they currently look like an address label prior to being dumped into Excel)
I am familiar with Excel basics - but don't know if what I am aiming for is even possible. If I could get this information into a spreadsheet to set up a Mail Merge, it would save my colleague many hours of mind numbing manual manipulation. Any ideas or suggestions gratefully recieved, thanks!
I am familiar with Excel basics - but don't know if what I am aiming for is even possible. If I could get this information into a spreadsheet to set up a Mail Merge, it would save my colleague many hours of mind numbing manual manipulation. Any ideas or suggestions gratefully recieved, thanks!