Overview
Grammar | CONCATENATE(text1,text2,...) | Joins at least two strings into one. |
Parameter 1 | Text1,text2, ... | Strings to be joined into one |
Notes
The function supports several parameters of any type.
Example
For example, if you want to join the Province field and City field into one, add a column and enter the formula CONCATENATE(Province, City). The results are shown in the following figure.
More examples:
| Formula | Result | Notes |
|---|---|---|
| CONCATENATE("Average ","Price") | Average Price | / |
| CONCATENATE("1","2") | 12 | / |
