String Concatenation

The string concatenation "&" operator is also known as the ampersand.
This operator can be used to join several text strings together into a single string.
When a text string is used within a formula the characters must be enclosed in speech marks " ".
You can use this operator to join any two values (text or numeric) in order to create a single text string.