how do i combine multiple rows that contain text

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