Merging multiple row same cell data into single sell.

[Peter]

I need to be able to merge multiple rows of data in the same column into a single cell quickly. For example cell c2, c3,c4 etc need to be compined into cell d2. Is there an easy way to do this?

Thanks in advance.

Peter

 

[J.E. McGimpsey]

One way:


D2: =C2 & C3 & C4

 

[Don Guillett]

=c2&" "&c3&" "&c4

I need to be able to merge multiple rows of data in the same column into a

single cell quickly. For example cell c2, c3,c4 etc need to be compined
into cell d2. Is there an easy way to do this?

 

[Peter]

works for fix # of rows how do I get it to work for variable #'s?

 

[Don Guillett]

copy down by locating the "grab" handle on the lower right of the cell and
dragging down.

 

[PETER]

Here is an example of what I'm trying to do:

part1 this
is
a
Test
Part2 this
Is
new
part3 one line