Combine text

L

Lisa

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
 
G

Gord Dibben

Do you want a macro?

It can be done without a macro using the ampersand.

=A1 & " " & B1 & " " & B2 & " " & B3


Gord Dibben MS Excel MVP
 
L

Lisa

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†didn’t work. The report looks like this.
Row 10001 – Help
Row 10002 Need
Your
Help
Row 10003 Thanks
 
G

Gord Dibben

Lisa

Copying the formulas would not take long, but if the data is inconsistent then
that throws a wrinkle into it.

I'll look at whipping up a macro but others here are pretty handy with the
formulas so hang in.

Someone can help.


Gord
 
L

Lisa

Any help would be greatly appreciated.

Gord Dibben said:
Lisa

Copying the formulas would not take long, but if the data is inconsistent then
that throws a wrinkle into it.

I'll look at whipping up a macro but others here are pretty handy with the
formulas so hang in.

Someone can help.


Gord
Click to expand...
 
Top