Extracting specific data with LEFT and RIGHT

- 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.…