Concatenate Function

In this topic, we will look at the Concatenate Function.


The Concatenate Function joins several text strings into one.


  1. Select the cell where the data will be entered.

    In this example, select cell C2.

    Step 1
  2. Click the Formulas tab.

    Step 2
  3. Click the drop down arrow next to the Text field.

    Step 3

    Step 4
  5. In the Function Arguments window, click in the Text1 box.

    Step 5
  6. Enter the cell reference for the first part of the string.  In this example, enter B2

    Step 6
  7. Click in the Text2 field.

    Step 7
  8. You must specify any spaces or punctuation that you want to appear in the results by using quotation marks in the appropriate Text box.  


    In this example, we want a space to separate our data. Enter:  " " (quotation mark  space quotation mark).

    Step 8
  9. Click in the Text3 field.

    Step 9
  10. Enter the cell reference for the second part of the string.   In this example, enter A2.


    You can add up to 255 text strings.

    Step 10
  11. Click the OK button.

    Step 11
  12. Here are the results.

    Step 12
  13. Use the Fill Handle in the lower right hand corner of the cell to apply the function to the remainder of the list.

    Step 13
  14. Release the mouse button.

    Step 14
  15. Here are the results!

    Step 15
  16. To remove the link between the referenced cells:


     Highlight the row with the concatenated data.


    Step 16
  17. Click the Home tab.

    Step 17
  18. Click the Copy button.

    Step 18
  19. Click the button to the right of the Paste field.

    Step 19
  20. Click the Values menu.

    Step 20
  21. By looking at the formula bar, you'll see the link between the cells is removed.


    Step 21

After completing the topic, you are able to apply and remove the Concatenate Function.