Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
combine columns | Excel Worksheet Functions |