Start a new line in cell within a function

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?
 
L

Leo Heuser

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

Space at end of multi page list to accommodate new entries 1
Interchange line break and paragraph break shortcut keys 9
List all tables, including document structure 0
Concatenate cells with line breaks in them 4
Concatentate text and insert blank line 2
find and replace numeric strings in larger text strings 8
Merge contents of cells and insert line space 3
how do you force a new line in a formula in Excel? 2

Top