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

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

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

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

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

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

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

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