creating labels from excel spreadsheet

S

SHARON

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?
 
T

thomsonpa

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top