In this tutorial learn how to do some common text operations; combine text using ampersand (&), separate text using Text to Columns, get one or more characters from the left using LEFT function.

Practice Sheet:
https://docs.google.com/spreadsheets/d/1lOhRt-9RwZR2gPbgi36EG8a78V1V9yYySv-hGILkb2E/edit?usp=sharing