Pasting multiple cells into a single cell
 

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

Pasting multiple cells into a single cell
 

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

"David" wrote in message
...
Is there a way to copy data from multiple cells and paste that data into a
single cell in Excel 2002?
--
Thanks,
David

Pasting multiple cells into a single cell
 

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"David" wrote:

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