ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert contents of various cells in a column into one cell? (https://www.excelbanter.com/excel-discussion-misc-queries/81077-insert-contents-various-cells-column-into-one-cell.html)

TextCells

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.

Pete_UK

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



All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com