Highlights
- Explore a completed concatenation
- Create a concatenation
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 (&)