inserting hard CR in a formula

  • Thread starter Thread starter Rick Morrison
  • Start date Start date
R

Rick Morrison

I am trying to write a formula to combine the contents of 3 cells into one
cell with a hard CR between each cell. Any ideas?

Thanks,

Rick
 
=A1 & CHAR(10) & A2 & CHAR(10) & A3

You will need to format the cell to wrap.

Regards,
Paul
 
You must log in or register to reply here.

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

How do I put a blank value in a cell not using "" in a formula 2
If/And function help 7
Transpose & offset data from a table 7
Excel VBA 1
Excel Need Countifs Formula Help 0
Average range of discontinuous cells 1
Change positive number to negative number 1
CountIf previous cell formula 0

Back
Top