Trouble with the line breaks

[Anonymous]

[Deleted]

[v-micsh-msft]

Hi @Anonymous,

I think here we should take use of  Char(13).

"One line here" & Char(13) & "Another line here"

Or take a try with Char(13) and Char(10) both:

"One line here" & Char(13) & Char(10) & "Another line here"

Thread reference:

String concatenate with new line

Check response from Staff rgruian.

"

Even though this post accepted a solution, for the record please note that you can append newline (CR) characters to any string.

    "new" & Char(13) & "line"

or:

    "new" & "

    " & "line"

If you need CRLF sequences instead, please use Char(13) & Char(10).

"

Regards,

Michael

[Anonymous]

[Deleted]