By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 135 - & - Concatenation


Concatenation is used to combine two strings into one. It's like an addition for strings.

If you want to combine the strings "a" and "b" you code "a" & "b". This works in both Excel formulas and in VBA.

The "+" symbol can also be used to combine strings "a"+"b" is an example.

Common Usages
  • In a loop to access a cell
  • To combine pieces to create a file name or folder name
  • variable in a formula
  • Pull in data from other cells

    In a loop to access a cell

    For i = 1 to 100
       Range("A" & i) = i
    next

    This will set
    A1 = 1
    A2 = 2
    A3 = 3
    ...
    A100 = 100

    To combine pieces to create a file name or folder name

    You can also see code with the =Concat() function also =Concatenate() in an Excel formula.

    ="c:\users\Al\downloads"&"-gcpar.zip"

    variable in a formula

    =HYPERLINK("https://example.com/project"&E3&"/operate")


    •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit