How To Copy MS Word mailing labels into Excel

  • Thread starter Thread starter Michael Rodriguez
  • Start date Start date
M

Michael Rodriguez

I have a word doc that I want to put into Excel. I want to add some
more fields to the names and addresses. Is this simple or do I have to
learn how to program?

Michael Rodriguez
City of Grand Prairie
 
Michael, have you tried to copy and paste the data into excel?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Paul B said:
Michael, have you tried to copy and paste the data into excel?

Yes. The Word doc is a 3x10 mailing label sheet. Addresses are already typed in. I did copy the contents into excel and for each address, cells were setup for each line. I would have to do alot of cutting and pasting to get a record for each address.
Click to expand...

Thanks for replying
 
Michael, you might want to try and transpose the data after you put it in
excel, to do this use Copy / Paste Special / Transpose.
If I was doing it, I would do the paste on a new sheet - or at least well
away from the existing data! Then you might have to do data text to columns
on some of the data.
If you want send me the word doc. and I will see what I can do

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
Michael Rodriguez said:
"Paul B" <[email protected]> wrote in message
Click to expand...
typed in. I did copy the contents into excel and for each address, cells
were setup for each line. I would have to do alot of cutting and pasting to
get a record for each address.
 
Back
Top