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.
