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)