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.
 
Back
Top