How to Use Excel's Concatenate Function

Excel 2010 and 2013's CONCATENATE function merges two or more strings of text into a single cell. Despite the term "strings of text," the function isn't limited to plain text. Use CONCATENATE to merge the results of multiple formulas, cell references and pieces of plain text into one cell.

Write a CONCATENATE Formula

CONCATENATE mixes text and formulas.
credit: Image courtesy of Microsoft

CONCATENATE Basics

To use the CONCATENATE function, write a formula starting =CONCATENATE( followed by each item you want to combine, separated by commas. To include strings of plain text, wrap the text inside quotation marks. For example, the formula =CONCATENATE("x","y") results in a single cell that reads "xy."

CONCATENATE Uses

You could simply type "xy" in a cell. CONCATENATE's real power lies in combining other formulas and cell references. For example, use =CONCATENATE(A1, "x") to merge the value in cell A1 with the letter x. CONCATENATE also works well to give results in full sentences: Use =CONCATENATE("The sum of column A is: ",SUM(A:A)) to display column A's sum in a complete sentence.

Use the Ampersand Shortcut

The same line using ampersands.
credit: Image courtesy of Microsoft

The ampersand operator serves as a shortcut for the CONCATENATE function, performing the same task with fewer characters. Instead of typing CONCATENATE( and placing commas between each item, place an & between each of the items. Other than this change, the cell behaves identically to one using the regular CONCATENATE method.