Aply the function CHAR

[Sara_Bertomeu]

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 · Accepted solution]

Hola Sara,

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

[Joseph_Seddik · Accepted solution]

Hola Sara,

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

[Sara_Bertomeu]

Hello Jose, 

So just with // ???

Thanks my friend

[Joseph_Seddik · Accepted solution]

Sin nada, una línea vacía 🙂

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

[Sara_Bertomeu]

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..