How to break line in formulas output

[zilvinas]

="Autorius: " & C2 & "Pavadinimas: " & D2 & "Kodas: " & B2 & "Leidykla: " & E2 & "Metai: " & F2 & "Būklė: " & G2 & "Kaina: " & J2 & “€” & "Aprašymas: " & M2

I want output get from new lines because I get so many information in one line and it’s “sticks” together.

I tried

="Autorius: " & C2 & newline & "Pavadinimas: " & D2 & newline & "Kodas: " & B2 & newline & "Leidykla: " & E2 & newline & "Metai: " & F2 & newline & "Būklė: " & G2 & newline & "Kaina: " & J2 & “€” & newline & "Aprašymas: " & M2

I tried newline but it doesn’t work. Any suggestions?

[sokol92]

Try this way:

="Autorius: " & C2 & CHAR(10) & "Pavadinimas: " & D2

[zilvinas]

Thank you! You saved my a ton of time