Pasting multiple cells into a single cell

D

David

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

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
 
S

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.
 
Top