Concatenate in Excel

The concatenate function is used to combine text from multiple cells into a single cell. It can be a very helpful tool if you don’t want to manually manipulate existing Excel data.

Concatenate Text

  1. Click where you want to insert the formula.
  2. Click the Formulas tab.
  3. Click theText Function button.
  4. Select CONCAT.
    CONCAT Function

    The concatenate function combines text exactly as it appears in a cell. If you want to add spaces or punctuation, you do so by putting the value you want to add in quotes (“ “) in a separate text field in the Function Arguments dialog box.

  5. Specify the text and any additional characters you want to join.

    The formula result appears at the lower-left corner of the dialog box. Verify it’s correct before completing the formula.

  6. Click OK.
    CONCAT Function

    The concatenate function looks at the values in the arguments and combines the specified text into one cell.

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.