How to convert PDF File into WHAT I NEED??

[Olivia K.]

Hi, So I have a PDF file of names and address's that I need to put into excel
- all fine and good EXCEPT when I copy and paste from the PDF it pastes with
the persons name at the bottom of their information
for example:
Orginal PDF:
Joe Smith
123 Happy Lane
Rockland, MA 19283

Copied PDF in WORD -
123 Happy Lane
Rockland, MA 19283
Joe Smith

* so first and formost is there anyway to correct that? I've tried just
about everything and I cant figure it out - since it is a PDF there probably
isnt any way -

now next most important question
When I copy into word it is listed like above (how a normal address would
look)
well unless I am really missing something there isnt any way to copy it
right into EXCEL - unless I edit it like this
joe smith 123 happy lane rockland, MA...
and put tabs in between where the colomn breaks are.

( I am so sorry if this is SO confusing)

Since I've gotten this evil project at work I've just been putting it into
notepad (or word) and editing it so I can just copy it right into excel.


I really dont know if that made any sense - I am trying to figure out a way
to get
Joe Smith
123 Happy Lane
Rockland...

all on the same line-

or I might just go postal at work =( I have over 5000 names/addresses to put
in.

oh and we dont have micro2007- they wont upgrade because all the old folks
like their 2003 to much =(!!!!!!! (but If i can figured out a way to do it on
07 then I'll just do it at home!)

THANKS SO MUCH IF YOU KNOW WHAT I MEAN?!

 

[Jay Freedman]

The procedure at http://www.gmayor.com/convert_labels_into_mail_merge.htm will
help, although it'll take some tweaking.

The overall idea is that you prepare the text with manual line breaks
(Shift+Enter) between the lines that are part of one entry, and paragraph breaks
(Enter) between entries. Then you can use the Table > Convert > Text To Table to
make a table where each entry is on one row, with the parts in separate columns.

You don't have to change the order of the stuff you got from the PDF before you
make the table. Once the table exists, you can select the column containing the
names and drag it to the left side of the table.

What you do next depends on _why_ you want to put the data into Excel. If it's
to make a mail merge source, you don't have to do that -- the Word table will do
just fine. If you have some other reason, then just copy the whole table, go to
a blank Excel worksheet, and paste.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all
may benefit.