Pro lesson · 6 exercises · first one free
Split and stack: TEXTSPLIT and VSTACK
About this lesson
Break a text into cells at a delimiter, and put ranges on top of each other (Excel 2024 and Microsoft 365).
Modern Excel and speed · 6 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Splitting a text into cells
- Stacking two lists into one
- Knowing which functions need a new Excel
- Splitting a list at a dash
- Putting two lists side by side
- Stacking ranges of different widths
Functions you'll use
- TEXTSPLIT
- VSTACK
- HSTACK
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 6, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.