excelisfun | Excel Formula: Extract City Name from Description. Excel Magic Trick 1839 @excelisfun | Uploaded 11 months ago | Updated 3 hours ago
Download Excel File: https://excelisfun.net/files/EMT1839.xlsx
Learn about how to extract the city name from a description using the SEARCH and LOOKUP functions. Then see how to spill the formula with BYROW and LAMBDA functions.
Buy excelisfuns book: The Only App That Matters:
Amazon: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700
Mr Excel Web Site: https://www.mrexcel.com/products/microsoft-365-excel-the-only-app-that-matters/

Topics:
1. (00:00) Introduction
2. (00:05) SEARCH and LOOKUP functions
3. (02:39) BYROW and LAMBDA functions
4. (03:43) Summary
5. (03:52) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #BYROW #LAMBDA #dataanalysis