Convert Addresses from PDF file into Excel

[zkiraly]

I am having a challenge at work. We have a client that emailed us an PDF file with addresses. There are over 200 pages and each page has 30 addresses (3 coloumns and 10 rows). When I try to copy and paste the addresses into excel, the addresses are all next to eachother and are pasted into excel as you would see an address on an envelope. But I need the parts of each address in a seperate column. For example column 1: name of company; column 2: name of recipient; column 3: address, column 4: city; column 5: state; column 6: zip

Any ideas?

Thanks,

Suzanna

 

[Michael M]

Without seeing the actual sample of how it pastes into Excel, have a look at Text to Columns to separate them

 

[Michael M]

Sorry, for some reason the rest of my message didn't come through...

When using Text to columns, select Delimited in the first screen and then select "Other" in the second screen
In the "Other" box hold down the ALT key and type 010
It will look like nothing has happened.....but it is there !!

 

[Miracle00]

it is really a huge task and also your pdf file maybe protected by some restrictions,such as do not permit to copy and paste.

 

[zkiraly]

Thanks Michael and Miracle for your suggestions.

The client finally sent us a usable Excel!