First of all, follow the steps shown in the prior method to insert the code into the Module.Ĭells(i, 4).Value = Cells(i, 2) & ' ' & Cells(i, 3).Now, in the previous method, we have to manually combine the string of text which can be tiresome if there are lots of cells. Next, click the Macros button > choose the Concatenate_StringPlus macro > hit the Run button.įinally, the output should look like the picture given below.At the very beginning, follow the Steps from the previous method to open the Visual Basic editor and enter the code.Lastly, the results should look like the image given below.Īlternatively, we can also use the Addition operator to join strings in VBA. Following this, select the Concatenate_StringAmpersand macro > hit the Run button.Third, close the VBA window > click the Macros button.Finally, combine the two variables with the Ampersand operator and return the result in the D5 cell.Then, store the values of the B5 and C5 cells in the Str1 and Str2 variables using the Range object.Next, define the variables Str1, Str2, and Result and assign String data type.First, the sub-routine is given a name, here it is Concatenate_StringAmpersand().Here, we’ll explain the VBA code used to concatenate strings with the Ampersand operator. Second, go to the Insert tab > select Module.įor your ease of reference, you can copy the code from here and paste it into the window as shown below.

Now, this opens the Visual Basic Editor in a new window.

First, navigate to the Developer tab > click the Visual Basic button.

Here, we have used the Microsoft Excel 365 version you may use any other version according to your convenience.įirst of all, let’s concatenate Strings using the Ampersand and the Addition operators in VBA.įor one thing, we can use the Ampersand operator in VBA, as we use it in the Excel spreadsheet, to join strings of text. So, without further delay, let’s see each method in detail and with the appropriate illustration. Here, we want to combine the “First Name” and the “Last Name” using VBA Code. 5 Ways to Concatenate String and Integer with VBAįirst and foremost, let’s consider the Employee Information dataset shown in the B4:E10 cells which contains the “First Name”, “Last Name”, “Country Code” and “Area Code” columns respectively.

Vba collection of integers