Merging multiple row same cell data into single sell.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=c2&" "&c3&" "&c4

Peter said:
I need to be able to merge multiple rows of data in the same column into a
Click to expand...
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?
 
copy down by locating the "grab" handle on the lower right of the cell and
dragging down.
 
Here is an example of what I'm trying to do:

part1 this
is
a
Test
Part2 this
Is
new
part3 one line
 
use the concatenate function
=concatenate(cell1#,cell2#, and if you go more than 3 you will need to put a space)

example:
=concatenate(A1,B3,D8," ",E6) - where "the-space", will add the space
 
Back
Top