Combine text from two or more cells into one cell

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Mobile.

Data from numerous cells can be joined into a single cell using the Ampersand symbol (&) or the CONCAT function.

Combine data with the Ampersand symbol (&)

  1. Choose the cell for placing the combined data.
  1. Enter = and click the first cell you want to merge.
  1. Enter & and use quotation marks with a space within.
  1. Click the next cell you want to integrate and hit enter. An example formula might be =B2&” “&C2.

Combine data using the CONCAT function

  1. Click whichever cell you want to insert the combined data.
  1. Enter =CONCAT(.
  1. Choose the cell you want to combine first. Use commas to divide the cells you are merging and use quotation marks to add spaces, commas, or other text.
  1. Finish the formula with a parenthesis and press Enter. An example formula might be =CONCAT(A2, ” Family”).

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

CONCAT function

TEXTJOIN function

Using Flash Fill in Excel

Combine data from multiple data sources (Power Query)

Overview of formulas in Excel

How to avoid broken formulas

Find and correct errors in formulas

Excel keyboard shortcuts and function keys

TEXT functions (reference)

Excel functions (alphabetical)

Excel functions (by category)

Leave a Reply

%d bloggers like this: