Simply defined, concatenation is the act of linking things together. In Microsoft Excel, the concatenation function is one of many text functions, which allows users to combine data distributed over multiple columns.
The concatenation of two or more numbers is the number formed by concatenating their numerals.
For example, the concatenation of 1, 234, and 5678 is 12345678.