Use the Ampersand symbol in Excel 1] Use the Excel CONCAT Function Excel has a function known as CONCAT, and it can be used to combine multiple contents in cells into a single cell.

With Excel 2016, Microsoft replaced the CONCATENATE function with the CONCAT function. You can still use the CONCATENATE function, however Microsoft recommends using CONCAT.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.