How do I combine cells? ex. first name, last name columns

L

LL

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
 
P

Paul B

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.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
 
J

JLGWhiz

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

Tom Ogilvy

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