From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Using FIND, MID, TEXTBEFORE, and TEXTAFTER functions to extract text data

Using FIND, MID, TEXTBEFORE, and TEXTAFTER functions to extract text data - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using FIND, MID, TEXTBEFORE, and TEXTAFTER functions to extract text data

“

- [Instructor] Excel is any number of text functions. Two of the most prominent ones are find and mid. We're about to use them here, but we're also headed toward the idea that sometimes there are much better choices and those choices are going to be the newer functions. Text before, text after introduced a few years ago. Let's talk about this idea. We've got some coding in column A and we'd like to extract the state name from it. And there could be hundreds of these. And we could start off with this idea and I'll zoom in a bit using the find function. The find function helps us find certain characters. Well, we could use this to find a dash, equal find, double quote dash, double quote, and we're looking in cell A two. That's it. Enter, it's in the second position. Now that's helpful by itself, but we're looking for the second dash. So what do we need to do? I could start this. What we really need to do is find, again, we have to find within a, the dash is located after where we found…

Contents