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 |