Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel Magic Trick # 155: VLOOKUP & TRIM function. That video is uploaded by excelisfun at 2008-12-02T14:10:50-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [YAVx8rmptUI]
| Name | Excel Magic Trick # 155: VLOOKUP & TRIM function |
| Video Uploader | Video From excelisfun |
| Upload Date | This Video Uploaded At 02-12-2008 22:10:50 |
| Video Discription | Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT155-167.xls Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT155-167Finished.xls Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT146-154.xls Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT146-154Finished.xls Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm When the VLOOKUP function should work and it does not, try the TRIM function to get rid of extra spaces. Use VLOOKUP & TRIM together in one formula when the values look the same but there are hidden spaces in the cell. This trick is good for when you get data dumped into Excel from a database that may have some extra spaces, or when employees add too many spaces during data entry. VLOOKUP retrieves the value and TRIM gets rid of extra spaces. Also see: YTLE#70 PivotTable & TRIM function & AVERAGES YAVx8rmptUI |
| Category | Science & Technology |
| Tags | Excel | VLOOKUP | TRIM | function | functions | formula | extra | spaces | Mike | Gel | Girvin | Highline | Community | College |
