Concatenate function in Ms. Excel

Concatenate function to combine some of the data contents of the cell

Syntax: = concatenate (text1: text2 ;...)

* Text1: text2; ... text to be combined, the format can be text, numbers, or cell address

The use concatenate function can be replaced with a mathematical operator / macro marks & is = X1 & X2 has the same value = concatenate (X1: X2)

Consider the following example:

Posted in: Concatenate function, Excel, Microsoft