View original (French)

Merge multiple cells with line break

Solved
Joluynes -  
Joluynes Posted messages 4 Status Member -
Hello,
and thank you in advance...

I'm trying to merge cells with a line break.
I'm using the CHAR(10) function which used to work but I must be writing the formula incorrectly. I've tried everything without success...
for example, 3 cells name/Address/City
to get
name
address
city
For your information, I'm working on Excel 2007

Have a good evening....

Configuration: Windows / Chrome 54.0.2840.71

3 answers

  1. Anonymous user
     
    Hello Joluynes,

    Without your specifications, the data cells and formulas
    are chosen at random (it will be up to you to adapt):

    If you have these 3 pieces of information:
    in A1: name
    in A2: address
    in A3: city

    I assume you put this formula in A5:
    =A1 & CHAR(10) & A2 & CHAR(10) & A3

    Note: The character code 10 is called LF (Line Feed) =
    line break; this is the code added when you
    manually type in a cell < Alt >< Enter >.

    Attention: That's not enough! Right-click on A5, then in
    the context menu, choose: "Format Cells" => window
    of the same name; select the 2nd tab: "Alignment";
    you need to check the following box:

    ☑ Wrap text

    This is what makes the character code 10 be
    properly used as LF; in fact, typing < Alt >< Enter >
    manually in a cell ensures that this box will be
    checked automatically.

    Best regards.  😊

    PS: Hello to Raymond while we're at it.  😉
    2