Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Learn how to add the text numbers at the end of a description to get a Sales Total using Excel worksheet formulas or Power Query Formulas. Extract Numbers from end of Description Trick.
Topics:
1. (00:00) Introduction
2. (00:14) Excel Worksheet Formula.See SUBSTITUTE, REPT, LEN, RIGHT and SUM worksheet functions.
3. (02:40) Power Query Formulas. See Query Editor Steps, Field Access Operator, and the List.Sum Power Query M Code Function.
4. (04:32) What happens when we get new data?
5. (04:47) Closing and Video Links

ExcelIsFunTue, August 10, 2021 2:08am