From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Extracting specific data with the LEFT and RIGHT functions

Extracting specific data with the LEFT and RIGHT functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Extracting specific data with the LEFT and RIGHT functions

“

- Excel has two companion text functions: one called Left, one called Right. They allow us to copy information from the left side of the cell or the right side of the cell. And after showing you how these two functions work, I'll also show you the relatively new feature called Flash Fill, introduced in Excel 2013 that, for many people, will negate the need for these functions. If we want to pull of, for example, the left-most information. Say just the Last Name from this list, we can't do it directly with the Left function. But we can do it in combination with another function called Find. If we know where the comma is, then we know that we want everything to the left of that. Let's start with this function called Find. And you might have seen this in a previous movie. We're looking for a comma here. "," Whatever we're looking for is within commas. And now a comma to indicate the second part of the function, the second argument, which is the location, A2. Find the comma there for us…

Contents