MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Concatenate Rows?????????

Posted by Danielle on February 21, 2001 4:49 AM


I hope someone can help as this is driving me crazy!! Does anyone know of a way of merging a number of rows in the same column into one single row other than using that concatenate function through Excel (using this I have to enter each line number and then it will only merge up to 30 lines). Basically, I have a paragraph of text that has been imported into Excel over a number of different lines. I now want to see them just in one.

Thank you!!!!


Posted by Celia on February 21, 2001 7:55 AM

Here's one way.
Select the cells you want to concatenate and then run this macro (it will put the concatenated cells in A1) :-

Sub MergeCells()
Dim cell As Range
For Each cell In Selection
Range("A1").Value = Range("A1") & " " & cell
End Sub