Definition of CONCATENATE
Appends strings to one another.
CONCATENATE(string1, [string2, ...])
string1- The initial string.
string2 ...- [ OPTIONAL ] - Additional strings to append in sequence.
- When a range with both width and height greater than 1 is specified, cell values are appended across rows rather than down columns. That is,
CONCATENATE(A2:B7)is equivalent to
CONCATENATE(A2,B2,A3,B3, ... , A7,B7).
SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
JOIN: Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
In order to use the CONCATENATE formula, start with your edited Excellentable:
Then type in the CONCATENATE formula in the area you would like to display the outcome:
By adding the values you would like to calculate the CONCATENATE formula for, Excellentable will generate the outcome: