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, &)