If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I am trying to combine a few cells of text into one which includes a line break. Is there a symbol I can use as part of my formula that will generate the line break?
Let's say cell A1 was "John", cell B1 "Doe", and cell C1 "25 years" and I wanted to combine them in a new cell in the following format:
John Doe
25 years
by formula
=A1&" "&B2&"<line break symbol>"&C1
where <line break symbol> is what I am looking for
don't forget to set the cell to wrap text and make the rows high enough to see all lines!!
__________________ teylyn
If you want to say Thank you to a member, click the reputation icon in the title bar of the post you liked
Everyone needs a pat on the back every once in a while!
Linear Mode
