Merge Row into One Cell with Line Break

jetheat

New Member
Joined
Mar 10, 2009
Messages
5
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
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Gary McMaster

Well-known Member
Joined
Feb 8, 2009
Messages
1,978
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)
 
Upvote 0

jetheat

New Member
Joined
Mar 10, 2009
Messages
5
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?
 
Upvote 0

Gary McMaster

Well-known Member
Joined
Feb 8, 2009
Messages
1,978
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
 
Upvote 0

jetheat

New Member
Joined
Mar 10, 2009
Messages
5
Ok, I just realized that it works in Windows Excel but not in the Mac version of MS Excel.

Any suggestions?

JH
 
Upvote 0

Gary McMaster

Well-known Member
Joined
Feb 8, 2009
Messages
1,978
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
 
Upvote 0

Forum statistics

Threads
1,196,015
Messages
6,012,861
Members
441,737
Latest member
bijayche

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top