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.

CONCATENATE(ROUND(RAND()*10); ROUND(RAND()*10); ROUND(RAND()*10))

returns xyz where x, y, z are three randomly independent digits, while:

REPT(ROUND(RAND()*10); 3)

returns nnn where n is a random digit repeated three times.