Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate to form a label
I have address information in 3 columns of cells that include name, address,
city/state/zip I want to combine these into a format similar to below: Ex: Adams, George 123 Groovy Lane Decatur, GA 34455 What should my formula include? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate to form a label
If you're actually forming a label, a far better alternative is to use
the XL worksheet as a data source for Word's Data Merge. For more see http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm http://www.mvps.org/dmcritchie/excel/mailmerg.htm In article , gwendalee wrote: I have address information in 3 columns of cells that include name, address, city/state/zip I want to combine these into a format similar to below: Ex: Adams, George 123 Groovy Lane Decatur, GA 34455 What should my formula include? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate to form a label
You should be using "mail merge" in Word together with your data in XL to
make your labels. Check out these links: 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 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "gwendalee" wrote in message ... I have address information in 3 columns of cells that include name, address, city/state/zip I want to combine these into a format similar to below: Ex: Adams, George 123 Groovy Lane Decatur, GA 34455 What should my formula include? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate to form a label
Assuming the 3 columns are A:C, in an adjacent column enter
=A1 & CHAR(10) & B1 & CHAR(10) & C1 Format to wrap text. I personally would not do this. Excel is not ideally suited for creating labels. Can be done through trial and error but Word is a much better Label creator using Excel as a source of data. Word likes the data in separate columns and rows as you currently have. For help on Word mail merge using Excel or Access 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 Gord Dibben MS Excel MVP On Mon, 15 Oct 2007 16:20:00 -0700, gwendalee wrote: I have address information in 3 columns of cells that include name, address, city/state/zip I want to combine these into a format similar to below: Ex: Adams, George 123 Groovy Lane Decatur, GA 34455 What should my formula include? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I concatenate information in Excel and keep the number form | Excel Worksheet Functions | |||
Hyperlink on a label in a VB Form | Excel Discussion (Misc queries) | |||
Can I re-number Excel Form Label Controls for orderly tabbing. | Excel Worksheet Functions | |||
COPY LABEL FORM FROM EXCEL TO A LABEL | New Users to Excel | |||
How do I take excel data and convert to label/envelope form? | Excel Worksheet Functions |