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:
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:
