Line break in Excel cell...

Solved
Fabienne -  
 Etienne -
Hello,

I just spent some time in the Excel help section, without a solution...

I need to compile several address columns (like: street1 street2 city and postal code) into a single cell. I can do that (with &) but I have everything on the same line. I also know that you can insert line breaks in a cell using Alt + Enter. But I can't do that manually for an entire column!!!... So I would like to insert line breaks into my formula with &, or insert an easily recognizable character and do a replacement afterward. But while I found the method in Word (insert paragraph break or line break using special characters), I can't find it in Excel. If I try, it inserts the characters as text and not their "effect" = line break...

Does anyone know a solution?

Thanks a million!

7 réponses

Catherine
 
Thank you! Simple and effective.
-1
ale
 
thank you
0
anonyme
 
Thank you, it's perfect!
0
coco
 
Thank you! It was simple and yet I couldn't find it.
0
Etienne
 
Thank you for the help!
0