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
Hi,
try
=A1&" "&B2&CHAR(10)&C1
don't forget to set the cell to wrap text and make the rows high enough to see all lines!!
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
In my standard template, I have a defined formula vbLf =CHAR(10) for just that purpose; then you can do =A1 & vbLf & B2 & vbLf & C1
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks