I’m asking for a friend 
She needs to create about 60 address labels in Word. The data is all in an Excel spreadsheet, with separate cells for name, street address, city, state, zip. Obviously copying a cell at a time would be a total PITA – is there some way to convert the spreadsheet into some form of Word doc that she could adapt more easily?
TIA.
Copy into Word.
Select the table, and convert “table-to-text”.
Find and replace Tabs with spaces.
“Copy” meaning what, a complete cut-and-paste of the chart into a blank doc?
And “table to text” is where, in the “edit” dropdown? Format?
Yeah. You can just highlight the whole table in Excel, press Ctrl-C, and paste it into Word.
Yup.
Depends on your version of Excel. In older versions, it should be a dropdown in Tables. In 2007, they did a dandy job of hiding it. It’s in…Layout->Convert to Text.
OR…
You could do a mail merge. For address labels, that would be the least overall work.
Great, thanks. I’ll pass on the info to my friend.
Okay, she got it into Word – now she’s stuck on making labels. Is there some trick to the mail merge?
(Seriously, this isn’t for me, this is for the office admin here.) (No, really.)
A little bit. I’d suggest Googling and getting step-by-step for a mail merge. They’re a tad tricky to set up, but in the long run will save you tons of time.
“Give me six hours to chop down a tree and I will spend the first four sharpening the axe.” – Abraham Lincoln
Thanks, Munch, I appreciate your help. I’ll have her google the specifics on the mail merge.
Also - if she’s using Avery labels (or something similarly standardized), she should definitely be using a mail merge to prevent her from royally screwing up and wasting some pretty expensive labels.