Copy from Rows and Paste into one Cell

[OceanBlue]

I need to Copy from several rows, like:
Quote Description:
Customer Site:
Order Type:
System Type:
Sales Campaign:
Applications:
Complete Quote By:
Estimated Cutover:
Delivery Method:


And Paste into one single Cell .

How can I do that?

[JBeaucaire]

You can concatenate string values together with a formula in a cell like so:

=A1 & B1 & C1
=A1 & ", " & B1 & ", " & C1

or perhaps:

=A1 & Char(10) & B1 & Char(10) & C1


Play around with those and notice the different results. The last one may require you to turn on Wrap Text.

[OceanBlue]

You can concatenate string values together with a formula in a cell like so:

=A1 & B1 & C1
=A1 & ", " & B1 & ", " & C1

or perhaps:

=A1 & Char(10) & B1 & Char(10) & C1


Play around with those and notice the different results. The last one may require you to turn on Wrap Text.

That Should Do it. Thanks.