SPLIT, JOIN and ARRAYFORMULA Functions in Google Sheets to Split Text & Add Numbers. GS 1. EMT 1684.

Download Excel File: docs.google.com/spreadsheets/d/1vLWTJeefLB1Qt5Ob9D… 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.

• #education
• #excel
• #highline_college
• #mike_girvin
• #excelisfun
• #excel_is_fun
• #excel_fun
• #excel_magic
• #excel_formulas
• #excel_functions
• #formulas_and_functions
• #excel_magic_trick_1684
• #emt
• #emt_1684
• #google_sheets
• #split_function
• #join_function
• #arrayformula_function
• #google_sheets_split_function
• #google_sheets_join_function
• #google_sheets_arrayformula_function
• #google_sheet
• #zstanojevic_at_youtube
• #excelisfun_google_sheets
• #excel_duel_192
• #mr_excel
• #mr_excel_excelisfun_trick_192