Line break in an EXCEL concatenation?

Question

Hello,
I would like to know how to create one or more line breaks in a cell calculated by concatenation.

Would a kind soul have an idea?

Note: the CHR(10) does not work.

Thank you in advance.

Configuration: Windows XP / Internet Explorer 6.0

fiddy · Accepted Answer

You need to concatenate with CHAR(10) (French version of Excel, or else CHAR(10)). For example: =A1 & CHAR(10) & A2 However, don't forget to make sure that the cell has the "wrap text" option checked.

fiddy · Answer

Have you tried typing in a cell and pressing alt + enter?

bidouille74 · Answer

Yes, if I do that, it works but the small report written in the cell is fixed; however, I want it to be created (concatenated) from several cells with a Line Feed (line break) between them. The goal is to copy the micro report all at once instead of copying each line.

I tried to create the cell without a formula, and it works. Then if I copy it, I can paste it, and the lines are well separated.
I still need to know how to automate the formula of the cell.

bidouille74 · Answer

Fiddy,  you are my master and I bow respectfully.  Indeed, I had tried everything except ..... checking the automatic return on the box format.  Great, it works.  Thanks again.

Line break in an EXCEL concatenation?

4 answers

The black swift flies for 10 months in a row without interruption

My pc won’t charge anymore and runs super slowly

Laptop: password forgotten

My second pc monitor

My computer stays connected for very little time

Unable to open xsl and xslx files

Pixma ts printer is broken

No internet connection possible

Print a page in the right orientation under windows 11

Change a contact’s ringtone