Combine text
It is a huge report and it would take a long time to combine all the cells.
The only problem is that the rows are not consistent. I tried to use the
€śif€ť and then €śconcatenate€ť didnt work. The report looks like this.
Row 10001 €“ Help
Row 10002 Need
Your
Help
Row 10003 Thanks
"Gord Dibben" wrote:
Do you want a macro?
It can be done without a macro using the ampersand.
=A1 & " " & B1 & " " & B2 & " " & B3
Gord Dibben MS Excel MVP
On Tue, 1 May 2007 12:20:02 -0700, Lisa wrote:
Does anyone know a macro that would combine these cells into one?
Thanks in advance
Actual Output
10001 Need
Your
Help
10002 Thank
You in
Advance
Desired Output
10001 Need Your Help
10002 Thank You in Advance
|