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.

When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, ...