Excel Function : CONCAT
Category
Text
Description
Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
Microsoft Excel Reference Page
https://support.office.com/en-us/article/CONCAT-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2
Syntax and Description of the CONCAT Excel Function
The syntax for the CONCAT function in Microsoft Excel is: =CONCAT(text1, text2, text3, …) where text1, text2, text3, … are the text strings that you want to concatenate.
About CONCAT Excel Function
The CONCAT function in Excel allows you to join together two or more text strings into one. For example, if you have a first name in one cell and a last name in another, you can use CONCAT to put them together in a third cell.