Difference between revisions of "Documentation/How Tos/Calc: CONCATENATE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Difference between REPT and CONCATENATE) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 22: | Line 22: | ||
: returns <tt>'''nnn'''</tt> where <tt>'''n'''</tt> is a random digit repeated three times. | : returns <tt>'''nnn'''</tt> where <tt>'''n'''</tt> is a random digit repeated three times. | ||
− | + | {{Documentation/SeeAlso| | |
− | + | * [[Documentation/How_Tos/Calc: REPT function|REPT]]''' | |
− | + | * [[Documentation/How_Tos/Calc: Text functions|Text functions]]''' | |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 13:35, 25 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.