Working With Functions in Excel 2016: CONCATENATE Function
Interactive

Working With Functions in Excel 2016: CONCATENATE Function

Biz Library
Updated Feb 12, 2019
Microsoft Office Excel 2016: Part 2 (Intermediate) - One of the most powerful text functions available in Excel is the CONCATENATE function. This function enables you to concatenate, or join together, text strings from multiple cells into a single cell. This function can save you massive amounts of time when you need to pull together data from multiple cells that already exists in your worksheets. (The CONCATENATE Function, Text Concatenation with the Ampersand, &)