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"
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"
"new" & "
" & "line"
If you need CRLF sequences instead, please use Char(13) & Char(10).
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand