From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

LEFT, RIGHT, and MID

LEFT, RIGHT, and MID

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

LEFT, RIGHT, and MID

“

- [Oz] Here we go. I'm going to show you left, right, mid. They can be very basic in what they do. And then you might ask me, "Oz, what is the point of this?" Well, we are here in advanced functions and formulas. And by the end of this video we will get pretty advanced. So, but let's look at this, the very basics. We've got these codes in column B and this is how we want to split 'em out. We see part one, part two, part three and we're going to use left, right, mid to peel these down. Now, first of all let's do one thing. I'm going to go, equals, len, open parentheses to make sure that all of these do have the same number of characters. Okay, so 12. Double click, boom. All of 'em do have 12, see? You just learned something new. You got the len function. All right, now we see that there is consistency in this data. To get started, I'm going to get rid of that. Okay. Next, I'm going to put this data into a table.…

Contents