Create carriage return using "=A1&A2" text merge?

G

Guest

I want to combine text from multiple cells into a single cell. I can do it by
using "=A1&A2" in the target cell. The problem is the text runs together. How
do I insert a carriage return to display the text from each cell on a new
line?
 
N

Nick Hodge

Try

=A1&CHAR(10)&A2

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select text before carriage return 2
Combining Text From Cells 3
carriage return in text cell in excell 2
Create carriage return using "=A1&A2" text merge? 2
Separating carriage return data into separate cells 2
Unicode text and carriage returns 4
Extend text to next cell 3
Excel - carriage returns and formating of text within a cell 2

Top