

Locate and Enable Power Pivot
Roman Kondratiuk
Use the ampersand (&) to join two or more data strings into one string.
Cells with text, numbers and formulas can be joined into a single string
Text added manually into a concatenation must be enclosed in “” and joined at each end with an ampersand (&)