How do I merge columns in LibreOffice Calc

Example:

 You can join the data in cell D1: =B1 & C1  Text between quotation marks will appear literally.

Or
Other Sample merge cell content in Libre Calc.
="Length is " & FORMAT(B1, "0,0") & " mm"