Text manipulation 1 : Concatenation
There are two methods available for concatenating text.
The ampersand symol & can be used as a concatenation operator on text - as shown below. This is analogous to the + operator for numbers.
There is also a CONCATENATE function - which can be used on up to 30 strings. The CONCATENATE function is also shown in the example below.
