Start a new line in cell within a function

  • Thread starter Thread starter John M
  • Start date Start date
J

John M

I'm using the concatenate function to combine the contents
of 3 cells in another worksheet. I'd like to insert a line
break between each of the strings (equivelant to ALT
+ENTER on the keyboard when editing a cell).

Anyone know how to do this in a function?
 
John

=CONCATENATE(Sheet1!A1,CHAR(10),Sheet1!A2,CHAR(10),Sheet1!A3)

Format the receiving cell with Alignment > Wordwrap
and give the column the proper width.

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 

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

Excel Concatenate with line breaks but ignore blank cells 3
Merge contents of cells and insert line space 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
how do you force a new line in a formula in Excel? 6
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
use of ADDRESS function within CELL function 4
How specify number format of cell value in concatenate function? 1
Concatentate text and insert blank line 2

Back
Top