Combining multiple rows
 

how do i combine multiple rows that contain text

Combining multiple rows
 

Whether you are asking about to add the cell contents OR Column?

If you want to combine multiple cell values then use this formula

A Column
20
60
Cat
89
Bat

The below formula will combine the A1 to A5 cell values
=A1&A2&A3&A4&A5
=CONCATENATE(A1,A2,A3,A4,A5)

The result will be like this:-
2060Cat89Bat

If you want to give space in between the cell values then use this formula

=A1&" "&A2&" "&A3&" "&A4&" "&A5
=CONCATENATE(A1," ",A2," ",A3," ",A4," ",A5)

Both the formulas will result the below values
20 60 Cat 89 Bat

Change the cell reference to your desired cell.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"dagdee" wrote:

how do i combine multiple rows that contain text