LinkBack URL
About LinkBacks
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
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
Like this?
=CONCATENATE(A2," ",B2," ",C2)
It does join them but it doesn't add a line break between each entry it has joined.
Can that be done?
Try this...
A2&CHAR(13)&B2&CHAR(13)&C2
Originally Posted by mpquin
No, that doesn't make a line break either.
Any more ideas?
JH
=CONCATENATE(A2,CHAR(13),B2,CHAR(13),C2,CHAR(13))
or
=CONCATENATE(A2,CHAR(10),B2,CHAR(10),C2,CHAR(10))
Maybe?
The above should work but the cell needs to be formatted with "Wrap Text" also.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
=CONCATENATE(B1,CHAR(10),C1,CHAR(10),D1,CHAR(10),E1,CHAR(10))
Then Format Cell - Wrap Text
Thanks
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.
then just drag out the column to make it wider
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I need it on separate lines. Not on one line. Each line has to be separated according to the cells they were in before.
Cell1 ------ Cell2 -------- Cell3
When joined together become:
Cell1 Cell2 Cell3
But I need it broken into lines like this:
Cell1
Cell2
Cell3
all in the same cell.
JH
The posts above contain the solution.
You need to make the column as wide as the widest single line text. The cell must be set to Wrap text, so the line break CHAR(13) can do its job. But if some of your text in one line is too wide for the cell, it will wrap the text to fit the cell. Thus you have to make the column as wide as the widest single line text.
O, I just realized that it works in Windows Excel but not in the Mac version of MS Excel.
Any suggestions?
JH
Dont use a Mac LOL, erm can you do it on windows then send to your mac? But as far as I am aware it should work exactly the same on your Mac.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks