Line break in Excel cell...
Solved
Fabienne
-
Etienne -
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!
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!