Pasting multiple cells into a single cell

[David]

Is there a way to copy data from multiple cells and paste that data into a
single cell in Excel 2002?

 

[John]

Hi David
You can do it this way: =A1&B1&C1 change cell range to your need, also if
you like space between each entry type it this way =A1&" "&B1&" " etc,etc
HTH
John

 

[Shane Devenshire]

The answer to your stated question depends on whether the enteries are
formulas, numbers or text.

If text no.

If formulas or number you can select one cell at a time and copy it, select
the target cell and choose Edit, Paste Special, Add.

But you must do it for each cell one at a time.