Home : CONCAT
Q11214 - INFO: CONCAT

CONCAT joins or concatenates the text strings together.  The str1.. str9 parameters can be quoted strings ("Sunny"), cell references (B5), or formulas that return a string (VT(1,1)). 

 

SYNTAX:

Concat(str1,str2,...str9)

str1..str9: Text to be joined together.  Can be quoted strings ("Sunny"), cell references (B5), or formulas that return a string (VT(1,1)). 

NOTES:

Returns a Text string.  Cell type will be changed to Text when using this formula.

EXAMPLES:

CONCAT("Hach ","Be Right") = Hach Be Right

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
In the example, CONCAT("OPS","SYSTEMS") = OPS SYSTEMS, would CONCAT("OPS SYSTEMS") have returned the same result? Approved: 4/26/2010 7:03 AM
Created on 5/9/2008 3:51 PM.
Last Modified on 9/12/2013 10:47 AM.
Last Modified by Scott Dorner.
Article has been viewed 4748 times.
Rated 5 out of 10 based on 1 vote.
Print Article
Email Article