Calc Guide

If cell A1 contains the numerical value 4 and cell B1 the numerical
value 5, the above examples would yield results of FALSE, FALSE,
TRUE, FALSE, TRUE, and TRUE.
Text operators
It is common for users to place text in spreadsheets. To provide for
variability in what and how this type of data is displayed, text can be
joined together in pieces coming from different places on the
spreadsheet. Figure 126 shows an example.
Figure 126: Text concatenation
In this example, specific pieces of the text were found in three
different cells. To join these segments together, the formula also adds
required spaces and punctuation enclosed within quotation marks,
resulting in a formula of =B2 & " " & C2 & ", " & D2. The result is
the concatenation into a date formatted in a particular sequence.
Taking this example further, if the result cell is defined as a name, then
text concatenation is performed using this defined name. Calc has a
CONCATENATE function which performs the same operation.
184 OpenOffice.org 3.x Calc Guide