I have a spreadsheet with multiple columns for first name, last name, address
state and zip. I need to combine first and last name, and also address,
state and zip in order to create mailing labels. How do I go about doing
this?

Thanks,

Laura

Laura, you have the information the the right format to do a mail merge with
word to print your labels

Have a look here for information on Word mail merge using Excel as the data
source
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm
--
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 2002 & 2003


"LL" wrote in message
...
I have a spreadsheet with multiple columns for first name, last name,
address
state and zip. I need to combine first and last name, and also address,
state and zip in order to create mailing labels. How do I go about doing
this?

Thanks,

Laura

See if this will help. On the Tools menu, point to Letters and Mailings, and
then click Mail Merge Wizard.

"LL" wrote:

I have a spreadsheet with multiple columns for first name, last name, address
state and zip. I need to combine first and last name, and also address,
state and zip in order to create mailing labels. How do I go about doing
this?

Thanks,

Laura

Sounds like something in MS Word, not Excel. Are you suggesting using MS
Word to do this with Excel as the data source?

--
Regards,
Tom Ogilvy

"JLGWhiz" wrote in message
...
See if this will help. On the Tools menu, point to Letters and Mailings,
and
then click Mail Merge Wizard.

"LL" wrote:

I have a spreadsheet with multiple columns for first name, last name,
address
state and zip. I need to combine first and last name, and also address,
state and zip in order to create mailing labels. How do I go about doing
this?

Thanks,

Laura