Module 5 : Lesson 1 Text Function Intro LEFT, RIGHT, SEARCH and LEN | Excel Training for Beginners
In this lesson, we will look how to use text functions in Excel, specifically the LEFT, RIGH, SEARCH and LEN functions. We'll start off with simple conceptual examples, the migrate into walking you through the process of extracting specific text from combined data, and cleaning up messy text.
And yes, the first few seconds the image is fuzzy, we we're playing around with video affects when this was made. :)
⌚ Timestamps
0:00 TEXT functions intro
0:23 RIGHT function
1:22 LEFT function
1:57 LEFT combined with SEARCH functions
4:07 RIGHT function combined with SEARCH and LEN
💾 CLASS FILE https://1drv.ms/x/s!AgnhzVKiTqWmch8Ec...