Documentation/How Tos/Calc: CONCATENATE function

CONCATENATE

Combines several text strings into one string.

Syntax:

CONCATENATE(text1; text2; ... text30)

returns up to 30 text strings text1 - text30, joined together.

text1 - text30 may also be single cell references.

Example:

CONCATENATE("al"; "tog"; "ether")

returns altogether.

CONCATENATE(A1; A2)

where cell A1 contains key and cell A2 contains board returns keyboard.

See also:

REPT

Text functions

Functions listed alphabetically, Functions listed by category