CODEWITHSUNDEEP
excelmergeexcel-formulaworksheet-function
user20159
user20159

Reputation: 175

How to merge contents of cell into one?

Does anybody know how to combine the contents of cells into one but still each piece of information in one separate line?

I have over 100 spreadsheets in which I have to do the same so I cannot do it manually.

picture example

Upvotes: 0

Views: 129

Answers (1)

pnuts
pnuts

Reputation: 59475

=A1&CHAR(10)&A2&CHAR(10)&A3&CHAR(10)&A4

with wrapping* will get you from A1:A4 to D1 but obviously may not suit your actual dataset. However, merged cells have been called an abomination (they are best avoided) so perhaps the one formula would suit in 100+ different spreadsheets - specially if all in the same book.

* Home > Cells - Format, Format Cells, Alignment, Text Control, tick Wrap text

Upvotes: 2

Related Questions