Learn 5 methods to split values in a column and learn how each method is best used and when to use them. Videos: EMT video 1904. Method: TEXTSPLIT. When to use: Use formula when you need instant update EMT video 1905. Method: Text To Columns. When to use: Use for one time event EMT video 1906. Method: Power Query. When to use: Use when importaing data EMT video 1907. Method: TEXTJOIN & TEXTSPLIT. When to use: Use when you need single cell formula to spill an array of arrays and there is less than 32767 characters EMT video 1908. Method: LAMBDA & REDUCE. When to use: Use when you need single cell formula to spill an array of arrays and there is more than 32767 characters
Curated by: excelisfun (5 videos)
Download Excel File: https://excelisfun.net/files/EMT1904-08.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Full playlist of splitting videos: https://studio.youtube.com/playlist/PLrRPvpgDmw0kvGUtN3lRyNbiCmYURc9_m/videos Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to use the Excel worksheet function TEXTSPILT to split delimited values in a column into multiple columns. Topics: 1. (00:00) Introduction. 2. (00:02) Five Total Videos: 1904, 1905, 1906, 1907, 1908. 3. (00:47) Download file to follow along. 4. (00:57) TEXTSPLIT function to spilt values by a delimiter. 5. (02:50) Why we use formula rather than Power Query or the Text To Columns feature. 6. (03:30) Bonus: Convert split text numbers to real numbers so you can use the SUM function to add spilt numbers. 7. (04:55) Summary & Closing. #excel #microsoft #excelisfun #excelcourse #mikegirvin #excel365 #textsplit #dataanalysis #cleandata #transformdata #data, #datacleaning #exceldataanalysis #excelfixdata #excelsplit #left #right #mid #exceltext #excelsplit #excelformulas #exceltips #exceltutorial #exceltricks #excelformula #splitcolumn This video has subtitles or audio translations in these languages: Afrikaans, Amharic, Arabic, Bangla, Chinese, Danish, Dutch, Dutch (Netherlands), Filipino, French (France), German (Germany), Hindi, Indonesian, Irish, Italian, Japanese, Khmer, Korean (experimental), Macedonian, Maithili, Malagasy, Malay, Malayalam, Nepali, Persian, Polish, Portuguese (Brazil), Russian, Sanskrit, Scottish Gaelic, Sicilian, Somali, Spanish, Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tigrinya, Turkish, Urdu, Vietnamese, Welsh, Zulu. Click gear icon below video to set subtitles, audio and language.