- If you want to extract data…from the left or right side of text cells,…there are two functions, actually called Left and Right,…that will help us get the job done pretty quickly.…Let's imagine that in column C…we've got some part numbers here,…and like some part numbers,…maybe the last three characters refer to…a location as to where the part was made,…or possibly it's the color,…but we need those last three characters on the right side.…Equal right, left parenthesis.…Here's the cell in question, comma, three.…

The three rightmost characters.…We're expecting to see 904, and that's what we get.…Double-click to copy down the column,…then you can see all the other results as well,…and once we see it, pretty obvious, pretty apparent.…Same kind of situation might occur here,…on these code numbers that we're looking at here.…We need to extract two characters from the left.…Equal left, looking at the data here, comma, two.…That's it, the number is 26.…There we are.…And in column F here, we'd like to extract the ZIP code.…

Resume Transcript Auto-Scroll

Author

Released

12/10/2014

Conquer some of the most daunting features in Microsoft Excel once and for all. In this version of his popular course, designed specifically for Excel for Mac users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.