Highline Excel 2013 Class Video 19: Text Functions RIGHT, LEFT, MID, SEARCH for Partial Text VLOOKUP

Download workbook: http://people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. Topics in this video: 1. Text Functions (00:11 min) 2. Partial Text Lookup: RIGHT & VLOOKUP (00:23 min) 3. Partial Text Lookup: LEFT and SEARCH & VLOOKUP (02:17 min) 4. Partial Text Lookup: MID & VLOOKUP (05:56 min) 5. Converting Numbers Stored As Text to Numbers (07:51 min)