If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying Multiple Cells to One Cells
Copying multiple cells into one cell as a summary. Eg I
have a list of items in seperate cells in one worksheet and wish to summarise them in another worksheet in one cell. Can this be done |
#2
|
|||
|
|||
Copying Multiple Cells to One Cells
=B2&C2&D2&E2 Will concatenate the value contained in the individual cells
B2,C2,D2 and E2. You can also use concatenate(B2,C2,D2,E2) unlikeKansas "Chas" wrote: Copying multiple cells into one cell as a summary. Eg I have a list of items in seperate cells in one worksheet and wish to summarise them in another worksheet in one cell. Can this be done |
#3
|
|||
|
|||
Copying Multiple Cells to One Cells
Hi
how do you want them to be summarised? maybe something like =A1 & "-" & B1 & "-" & C1 will do? -- Regards Frank Kabel Frankfurt, Germany Chas wrote: Copying multiple cells into one cell as a summary. Eg I have a list of items in seperate cells in one worksheet and wish to summarise them in another worksheet in one cell. Can this be done |
#4
|
|||
|
|||
Copying Multiple Cells to One Cells
Hi Chas
if you wanted spaces or commas between the values you will need to include them in the formula:- e.g. =B2 & " " & C2 & " " & D2 or =B2 & ", " & C2 & ", " & D2 or if using the concatenate function =Concatenate(B2," ",C2," ",D2) and, of course, being in another workbook you'll need to include the workbook name & sheet name in each of the formula elements. Which leads me to my next question .. is it necessary that the summary is dynamically linked to the first workbook or could you concatenate them in the first workbook somewhere and then copy / paste special - values the RESULT only to the summary book? If it needs to be dynamic then i would suggest concatenating them in the first book and linking the concatenated cell to the second. Hope this makes sense Regards JulieD "unlikeKansas" wrote in message ... =B2&C2&D2&E2 Will concatenate the value contained in the individual cells B2,C2,D2 and E2. You can also use concatenate(B2,C2,D2,E2) unlikeKansas "Chas" wrote: Copying multiple cells into one cell as a summary. Eg I have a list of items in seperate cells in one worksheet and wish to summarise them in another worksheet in one cell. Can this be done |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
range name vs multiple cells | Carole O | Worksheet Functions | 1 | July 21st, 2004 11:34 AM |
Copying Cells without changing data | That's Confidential | Worksheet Functions | 4 | March 26th, 2004 08:34 PM |
link multiple cells from other workbook on another machine on network | Bryce | Links and Linking | 2 | October 13th, 2003 04:58 PM |