Merging multiple row same cell data into single sell.


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
 
Ad

Advertisements

D

Don Guillett

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

Peter said:
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?
 
D

Don Guillett

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

Guest

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

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

Advertisements

Joined
Feb 10, 2016
Messages
2
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top