How to Use Concatenate in Excel

By Lysis

Microsoft Excel is a spreadsheet application that allows users to create reports or keep track of numbers such as inventory, payroll and sales. Within the Microsoft Excel software is the ability to create formulas. Excel uses a simple version of Visual Basic called Visual Basic for Applications (VBA). This programming language has functions that users can use to do quick formulas in the Excel spreadsheet cells. One function in the VBA language is the "Concatenate()" function.

Step 1

Open the Excel spreadsheet you want to edit or create a new spreadsheet. The concatenate function works with any recent version of Excel.

Step 2

Type a word in the A1 field in the Excel spreadsheet. For example, type the your first name into the A1 field as a test.

Step 3

Type a word into another field. For this example, type your last name into the B1 field in the Excel spreadsheet.

Step 4

Type "=concatenate(a1,b1)" into the C1 cell in Excel. The equal sign indicates that what is entered into the cell is a formula and isn't a literal string. For instance, if the A1 cell contains "John" and the B1 cell contains "Smith," The C1 cell contains "JohnSmith." To add a space to the name, add a string to the concatenation with the following syntax: =concatenate(a1," ",b1)The code above displays "John Smith" in the C1 field.

Step 5

Type a word into a third cell and add it to the concatenation function. The concatenation function can take several cells and combine them together. You can concatenate several cells by using "=concatenate(a1, b2, c3)."

Tips & Warnings

  • You can also concatenate strings. For instance, "=concatenate("John ", "Smith")" will display "John Smith."