Convert data to single cell format

[Wizards]

I've got multiple tables of data organised in blocks of 4 cells each.

I need to convert the data in these 4 cells into one cell but still have it on separate lines within the cell.


I can't think of a way to do that so if anyone could help it would be much appreciated.

[Sindhus]

Use char(10) while concatenating the cells. =A1&Char(10)&B1&Char(10)&C1

After writing the formula, use wrap text to view it as separate lines within the cell.

[Wizards]

Sindhus,

that was great - perfect in fact.

So char(10) is essentially the [enter] key?

[jeffreybrown]

Char(10) is a Line Feed

It is the same as Ctrl + Enter