Difference between revisions of "Documentation/How Tos/Calc: CONCATENATE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 23: | Line 23: | ||
{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||
− | * [[Documentation/How_Tos/Calc: REPT function|REPT]] | + | * [[Documentation/How_Tos/Calc: REPT function|REPT]] |
− | * [[Documentation/How_Tos/Calc: Text functions|Text functions]] | + | * [[Documentation/How_Tos/Calc: Text functions|Text functions]] |
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 13:56, 26 February 2009
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.