MM0051 - 23/11/20 - Separate Text Into Cells With Excel Formulae And VBA
Being able to work with text in Excel is an essential skill. In this stream, we use Excel formulae to separate a sentence into words in cells.
*APOLOGIES FOR INITIAL AUDIO - IMPROVES AFTER 12 MINUTES*
Topics
*APOLOGIES FOR INITIAL AUDIO - IMPROVES AFTER 12 MINUTES*
Topics
- | Split Text Across Cells - Concepts
- | Formulae To Analyse Text
- | FIND
- | Combine Multiple FIND Formulae
- | MID
- | Why Don't Universities Teach Excel?
- | VBA vs. Formulae Working With Text
- | INSTR to find text in a string
- | Create Content!
- | Do Until Loop Example
- | Msgbox And Step Into To Debug
- | One-Line Conditional Explanation
- | Example Of Unhelpful Error Message
1 Lesson