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).
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
Learn how to build the business apps that you need.