Aply the function CHAR

[anonymous]

Hello again:

My new adventure, the TEXT.

I try to add some new line LINE BREED with the function CHAR()

=CONCATENATE(A1,CHAR(10),B1).

How can I do it?? Thanks

[Joseph_Seddik]

Hola Sara,

CONCATENATE([columnA], "
// this is a manual, explicit, empty line
", [columnB])

[anonymous]

Hello Jose,

So just with // ???

Thanks my friend

[Joseph_Seddik]

Sin nada, una línea vacía

CONCATENATE([columnA], "
", [columnB])

[anonymous]

ahhhhhh, jajajjaja, que inculta soy, joe!!! Gracias

I copy the example solution:

CONCATENATE(
"
“,“ID:”,[ID_ROW],” ",
"
","NOTAS: ",[NOTAS], " ",
"
","Pax: “, [PAX] ,” ",
"
","ORIGEN: ",[CALENDARIO ORIGEN], " ",
"
","Link: “, [WEB LINK],” ",
"
","Ref: ",[Número de reserva]
)

[Joseph_Seddik]

No no era algo evidente..