How to Use Concatenate in Excel

Written by lysis
  • Share
  • Tweet
  • Share
  • Email

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.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

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

  2. 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.

  3. 3

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

  4. 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.

  5. 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 and warnings

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

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.