Episode 159 - Get characters up to the Dash
The Left, Mid, Right functions are great, but what if you need to grab a variable number of characters from the left portion of the cell? For example, you need all of the characters up until the first dash? In this case, you will have to use =FIND() to find the position number of the dash. This episode also demonstrates a cool trick for combining functions. When you need to create a complex formula, you might build one part of the formula in one column and the rest of the formula in a second column. This episode shows a unique trick for copying the function from the first column and pasting it into the formula bar of the second function. Episode 159
shows you how.
This new blog is the video podcast companion to the new book, Learn Excel from MrExcel
. Download a new two minute video every workday to illustrate one of the 277 tips from the book!
Labels: Find, formulas, LEFT, MID, RIGHT