Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a cell with a list of values (#s, text) from other cells
I am trying to make a label from an Excel file. The content for one of the
cells to be printed is found in other cells on a different worksheet of the same file. How do you automatically put the values (#s and text) from multiple cells as a list into one cell (the one to be printed)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a cell with a list of values (#s, text) from other cells
Try the formula
=Sheet2!A1 & " " & Sheet3!A1 OR =Sheet2!A1 & char(10) & Sheet3!A1 'Apply wraptext to this cell to list down the values in separate lines.. If this post helps click Yes --------------- Jacob Skaria "akutach" wrote: I am trying to make a label from an Excel file. The content for one of the cells to be printed is found in other cells on a different worksheet of the same file. How do you automatically put the values (#s and text) from multiple cells as a list into one cell (the one to be printed)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a cell with a list of values (#s, text) from other cells
And if you need a special format (fixed decimals, leading 0's, times or date or
money or...): =text(a1,"00.000")&text(b1,"hh:mm:ss")&text(c1,"mm/dd/yyyy") akutach wrote: I am trying to make a label from an Excel file. The content for one of the cells to be printed is found in other cells on a different worksheet of the same file. How do you automatically put the values (#s and text) from multiple cells as a list into one cell (the one to be printed)? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a cell with a list of values (#s, text) from other cells
But if you're making labels to print, you may want to use excel as your database
and MSWord to do the work. Saved from a previous post: Lots of times, it's easier to use MSWord for printing and Excel (or some other database application) as the source. You may want to read some tips for mailmerge. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. And if you notice problems with the formatting of data (like zipcodes)... Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"ddmmyy") or =text(a2,"mm:ss.0") or =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) akutach wrote: I am trying to make a label from an Excel file. The content for one of the cells to be printed is found in other cells on a different worksheet of the same file. How do you automatically put the values (#s and text) from multiple cells as a list into one cell (the one to be printed)? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you add cell values to drop down list for other cells | Excel Discussion (Misc queries) | |||
How do I make Excel drop-down list values editable? | Excel Worksheet Functions | |||
Make unique cells - Avoid repeating Values | Excel Discussion (Misc queries) | |||
List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
make list of information from different cells | Excel Worksheet Functions |