Concatenating
You can use "+" for concatenation although it is not recommended as this is a WordBasic operator. You should use "&".
When using the string concatenation character "&" be sure to insert a space before and after this operator.
String Concatenation (&)
This operator can be used to join two or more strings together.
This operator can also automatically convert between types as it combines a resultant string.
It can be used to combine several different variable types into a string without any explicit conversion.
Dim sMyLongString As String
Dim sShortString As String
sShortString = "Monday"
sMyLongString = sShortString & " " & "some more text"
Msgbox sMyLongString ' = "Monday some more text"
String Concatenation (+)
This can also be used as a string addition operator to join two or more strings together.
If you try to use this operator with multiple variables types you will receive a "Type Mismatch" error.
Dim MyNumber As Variant
MyNumber = "2"
MyNumber = MyNumber + MyNumber + MyNumber
Msgbox MyNumber ' "222"
JOIN Function
JOIN - Returns a text string containing all the elements in an array (String).
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext