Merge multiple cells with line break
Solved
Joluynes
-
Joluynes Posted messages 4 Status Membre -
Joluynes Posted messages 4 Status Membre -
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
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 réponses
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. 😉
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. 😉
