D David Jan 27, 2009 #1 Is there a way to copy data from multiple cells and paste that data into a single cell in Excel 2002?
Is there a way to copy data from multiple cells and paste that data into a single cell in Excel 2002?
J John Jan 27, 2009 #2 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
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 Jan 29, 2009 #3 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.
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.
