33up PDF to Excel

  • Thread starter Thread starter Jarbacky
  • Start date Start date
J

Jarbacky

Hello - I have rec'd several files from a client in PDF format - as if
to print on avery 33up labels in this format

Fullname,
address
city state zip

Is there an easy/fast way to convert to 3 column Excel? I can get all
into 1 column but then have to cut and paste a lot. Any suggestions?

Thanks so much!

Bec
 
Assuming the first name is in A1
In D1 enter =INDIRECT("A"&ROW()*3-2)
In E1 enter =INDIRECT("A"&ROW()*3-1)
In F1 enter =INDIRECT("A"&ROW()*3)
Select the three cells and drag down the column to capture all the data

Now select all the data in columns D, E and F;
Copy all this data
With it still selected, use Edit | Paste Special with Values specified

And you are done
best wishes
 
Back
Top