CONCATENATE Function /text/scalc/01/func_concatenate.xhp CONCATENATE function

CONCATENATE

Combines several text strings into one string.

CONCATENATE() String 1[; String 2][; … ;[String 255]] are strings or references to cells containing strings.

=CONCATENATE("Good ";"Morning ";"Mrs. ";"Doe") returns: Good Morning Mrs. Doe.

CONCATENATE wiki page.