DESCRIPTION Topics in this video: (00:11) Text Functions. (00:23) Partial Text Lookup: RIGHT & VLOOKUP. (02:17) Partial Text Lookup: LEFT and SEARCH & VLOOKUP. (05:56) Partial Text Lookup: MID & VLOOKUP. (07:51) Converting Numbers Stored [Read More >>>]
Extract Dates from Cell With Dates and Words DESCRIPTION See Mr Excel and excelisfun Extract Dates from Cell With Dates and Words using two different methods. See the functions: DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, [Read More >>>]
DESCRIPTION In this video learn how to rearrange a product code using Excel Spreadsheet Functions and Power Query Functions. Also see that Flash Fill does not seem to work. Learn the Power Query equivalent for [Read More >>>]
Be the first to comment
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.