| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert contents of various cells in a column into one cell?
Can anyone help me insert the contents of several cells in a column into one
cell? The contents of the different cells in the column are just text. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert contents of various cells in a column into one cell?
You can join text together by means of the concatenation operator - &,
like this in cell D1: =A1 & B1 & C1 Hope this helps. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| How to insert a value in one cell into many cells | Excel Worksheet Functions | |||
| How to insert the contents of two cells in a footer? | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
