Difference between revisions of "Documentation/How Tos/Calc: CONCATENATE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
(added single cell refs) |
||
Line 7: | Line 7: | ||
<tt>'''CONCATENATE(text1; text2; ... text30)'''</tt> | <tt>'''CONCATENATE(text1; text2; ... text30)'''</tt> | ||
: returns up to 30 text strings <tt>'''text1'''</tt> - <tt>'''text30'''</tt>, joined together. | : returns up to 30 text strings <tt>'''text1'''</tt> - <tt>'''text30'''</tt>, joined together. | ||
+ | |||
+ | : <tt>'''text1'''</tt> - <tt>'''text30'''</tt> may also be single cell references. | ||
=== Example: === | === Example: === | ||
− | <tt>'''CONCATENATE(" | + | <tt>'''CONCATENATE("al"; "tog"; "ether")'''</tt> |
− | : returns <tt>''' | + | : returns <tt>'''altogether'''</tt>. |
+ | |||
+ | <tt>'''CONCATENATE(A1; A2)'''</tt> | ||
+ | : where cell A1 contains <tt>'''key'''</tt> and cell A2 contains <tt>'''board'''</tt> returns <tt>'''keyboard'''</tt>. | ||
=== See also: === | === See also: === |
Revision as of 19:26, 25 January 2008
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.