Copying Multiple Cells to One Cells

C

Chas

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
 
U

unlikeKansas

=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
 
F

Frank Kabel

Hi
how do you want them to be summarised?
maybe something like
=A1 & "-" & B1 & "-" & C1
will do?
 
J

JulieD

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
 
Top