Download Excel File: https://docs.google.com/spreadsheets/d/1vLWTJeefLB1Qt5Ob9DG5XlfCnG-g5qhFosH1arWnfyQ/edit?usp=sharing

Learn how to split text numbers, then add a number to each and then re-join using the Google Sheets Functions: SPLIT, JOIN and ARRAYFORMULA. Trick thanks to zstanojevic at YouTube.

Topics:
1. (00:00) Introduction.
2. (00:23) SPLIT Function
3. (00:50) ARRAYFORMULA Function.
4. (01:12) JOIN Function.
5. (01:43) Summary and Video Links.