Join Text Strings Using Concatenate or ‘& Operator’ in Excel
This example illustrates how to concatenate (join) strings in Excel. When joining text and a number, use the TEXT function to format that number. 1. Simply use the & operator to join strings. Note: to insert a space, use ” ” 2. The CONCATENATE function produces the exact same result. 3a. The CONCAT function in Excel 2016 produces the exact …