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 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

Minecraft restore the cursor and the bar.

My ps3 keeps shutting down on its own...

Samsung series 4 led tv logo display...

How to enable bluetooth on a samsung tv?

Ctrl key issue

[metin2] sura ...

Freebox tv locked step 2 or network

Error 46 (brother dcp-150c) cleaning impossible