In Excel, the Concatenate function allows you to join 2 or more strings together.
The syntax for the Concatenate function is:
Concatenate( text1, text2, ...
text_n )
There can be up to 30 strings that are joined together.
To concatenate multiple strings into a single string in Excel, you can also use the "&" operator to separate the string values.
string_1 & string_2 & string_n
VBA Code
The "&" operator can be used to concatenate strings in VBA code.
For example:
LValue = "Alpha" & "bet"
