Merge Row into One Cell with Line Break

[jetheat]

I have a row of data. I want to merge it all into the first cell and have a line break between each line (from each of the cells).

Any idea how I can do this?

Appreciate the help,

JH

 

[Gary McMaster]

The formula below will merge with line feeds.
You must switch on "wrap" in the cell containing the formula.

Hope it helps.

Gary

=CONCATENATE(A2,(CHAR(10)),B2,(CHAR(10)),C2)

 

[jetheat]

It will wrap the text but it will wrap it according to how wide the cell is.

I need every bit of data from one of its previous cells on its own line (a line break) as if hitting the enter key.

Any suggestions?

 

[Gary McMaster]

I don't think I know what you want.

Char(10) is the line feed character and should be putting value from each cell on its own line. If you make the column wide enough, the formula above will yield 3 seperate lines in a single cell.

If you are looking to transpose row members into their own cells in a column then have a look at "Paste special" with the "Transpose" option.

Gary

 

[jetheat]

Ok, I just realized that it works in Windows Excel but not in the Mac version of MS Excel.

Any suggestions?

JH

 

[Gary McMaster]

Just a guess.

Maybe the Mac uses something other than character #10 for a linefeed. Check the character codes in Mac help and see if that is the case. Surely they must have some kind of a linefeed character.

Gary