| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste into one cell
Can't do it with copy paste, but you can concatanate them:
If you cells are A1, B1, C1 and the destination is D1 you would type i D1: =A1 & B1 & C1 If you need to add spaces between, use =A1 & " " & B1 & " " & C1 -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Paste using cell link option Half works | Excel Worksheet Functions | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
| Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) | |||
![kkknie[_94_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
