| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate Multiple Cells into A Single Cell | Excel Discussion (Misc queries) | |||
| How to Copy single Cell into Multiple cells | Excel Worksheet Functions | |||
| Using a single cell value to repopulate multiple cells | Excel Worksheet Functions | |||
| Using a single cell value to repopulate multiple cells | Excel Discussion (Misc queries) | |||
| Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions | |||
Linear Mode
