Fortunately, Excel 2016 (and all prior versions) make it very easy to grab data from many different cells and put it into one. Just don’t confuse this “combining” with “merging,” another Excel procedure which causes one cell to span across multiple columns, but only uses the content from that single cell. To combine cells in Excel:

  1. Select a location where you want the new, combined cell(s) to appear. Most likely, you’ll want to pick a new column that’s to the right of your other cells, but you don’t have to.
  2. Type =B2&C2 into the formula bar where B2 and C2 are the addresses of the cells whose data you want to combine (it could be any two cells). You can use an unlimited number of ampersands to add an unlimited number of cells.
  3. Include spaces between cells by adding &" " to the forumla. Anything within the quotes will be rendered so it could be a space, a comma or any text you want.
  4. Hit Enter to see how it renders
  5. Copy and paste your formula to reproduce the results in other rows.

Microsoft Excel Tips

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special