View original (French)

Excel Concatenation - Line Break

swagger79 Posted messages 2 Registration date   Status Membre -  
 amigo -
Bonjour
I am looking for the line break instruction in string concatenation in Excel

Example

A1= Hello
A2= Thibaut

A3=CONCATENATE(A1;CHAR(10);A2)

In the end, if I paste cell A3 into a text file, I would like it to give

Hello
Thibaut

Is there this "magic" instruction that I call CHAR(10)

I don’t mind the result it gives in Excel, since I only use it to "build" another file

Thank you for your help
Configuration: Windows XP Internet Explorer 6.0

4 réponses

Réponse 1 / 4
amigo
 
Hello,

Try car(13) & car(10) which means Carriage_Return New_Line (like in the old typewriters)
In text files, the RC NL sequence is automatically added at the end of each line.

Hi
9