
The CONCAT function joins text from multiple cells into a single string. This is helpful when combining first and last names, addresses, or labels into one field.
For example, =CONCAT(A1," ",B1) joins two text values with a space in between. Text functions like this are useful for cleaning and restructuring data.
Reference:
TaskLoco™ — The Sticky Note GOAT