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

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

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