excelisfun | Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817 @excelisfun | Uploaded 1 year ago | Updated 12 hours ago
Download Excel File: https://excelisfun.net/files/EMT1817.xlsm

Learn about how take CSV Number Data like 12, 12, 12, 12 and add to get 48. See a Microsoft 365 formula and then an Excel Formula that will work in any version of Excel!
Topics:
1. (00:00) Introduction
2. (00:04) Goal of Video
3. (00:26) Microsoft 365 Formula: TEXTSPLIT and SUM
4. (01:23) Formula that works in any version: SUBSITUTUE function
5. (02:12) Excel 4.0 Macro Function and Macro Sheet
6. (03:09) EVALUATE function
7. (04:11) Relative Cell Reference in a Defined Name
8. (05:08) Closing, Video Links

#excelisfun #excel #excelformulas #freeclass #excelfunctions #addtext #freeclasses #freecourse #textfunction #textsplit #evaluate #macro #analytics #spreadsheet #worksheet #exceltricks #exceltextfunctions