Syntax
|
expression1
&
expression2
|
Description
|
Returns the concatenation of expression1 and expression2.
|
Comments
|
If both expressions are strings, then the type of the result is
String
. Otherwise, the type of the result is a
String
variant.
When nonstring expressions are encountered, each expression is converted to a
String
variant. If both expressions are
Null
, then a
Null
variant is returned. If only one expression is
Null
, then it is treated as a zero-length string.
Empty
variants are also treated as zero-length strings.
In many instances, the plus (+) operator can be used in place of
&
. The difference is that
+
attempts addition when used with at least one numeric expression, whereas
&
always concatenates.
|
Example
|
This example assigns a concatenated string to variable s$ and a string to s2$, then concatenates the two variables and displays the result in a dialog box.
Sub Main()
s$ = "This string" & " is concatenated"
s2$ = " with the '&' operator."
MsgBox s$ & s2$
End Sub
|
See Also
|
+ (operator); Operator Precedence (topic).
|