Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating labels from excel spreadsheet
i have a spreadsheet with 5 columns of data that contain address information.
Ex. column A = name, column B = Company, column c = Street etc. How do i get those columns to come together and be able to print them onto Avery mailihng labels? -- Thanks, Sharon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating labels from excel spreadsheet
Mail merge Excel to Word:
a.. http://www.mvps.org/dmcritchie/excel/mailmerg.htm b.. http://www.mvps.org/word/FAQs/MailMerge -- David Biddulph "SHARON" wrote in message ... i have a spreadsheet with 5 columns of data that contain address information. Ex. column A = name, column B = Company, column c = Street etc. How do i get those columns to come together and be able to print them onto Avery mailihng labels? -- Thanks, Sharon |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating labels from excel spreadsheet
If you want them combined in one line use the & symbol: Example
=A1&" "&B1 The " " is to insert a space. This will give you the contents of cell A1 then a space then the contents of B1 However, it would probably be easier to use the mailmerge in Word, you can use the contents of an Excel spreadsheet for the data. To try and print labels in Excel is difficult as the cell sizes change when information is entered. To avoid this, set your cell format under alignment tab to shrink to fit, once you have created your template. "SHARON" wrote: i have a spreadsheet with 5 columns of data that contain address information. Ex. column A = name, column B = Company, column c = Street etc. How do i get those columns to come together and be able to print them onto Avery mailihng labels? -- Thanks, Sharon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating labels with excel and mail merge | Excel Discussion (Misc queries) | |||
Access or Excel for contact info lists & creating mailing labels | Excel Discussion (Misc queries) | |||
Creating Column and Rows labels in excel 2003 | Excel Discussion (Misc queries) | |||
Creating Address Labels in Excel | Excel Discussion (Misc queries) | |||
How do I print labels from an Excel spreadsheet | Excel Discussion (Misc queries) |