Excel: Concatenate with &

To concatenate multiple strings into a single string in Excel, you can use the "&" operator to separate the string values.

string_1 & string_2 & string_n

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=A1&A2 would return "Alphabet"

="Tech on the "&"Net" would return "Tech on the Net"

=(A1&"bet soup") would return "Alphabet soup"

VBA Code

The "&" operator can be used to concatenate strings in VBA code. For example:

Dim LValue As String

LValue = "Alpha" & "bet"