Download Excel File: https://excelisfun.net/files/MrExcelExcelisfunTrick192.xlsm
Sub to Bill Mr Excel Jelen: https://www.youtube.com/channel/UCXbicpVq_ALWG4ijPKsR7ZQ
How to Add 500 to All Numbers in Text String. A VBA method from Mr Excel and two formula methods from excelisfun!
Topics:
1. (00:00) Duel Song
2. (00:31)Introduction
3. (01:13) Mr Excel VBA Method
4. (03:13) VBA wins!
5. (03:28) Shout Out To #1 Excel Video Guy in the world; Bill Mr Excel Jelen
6. (04:12) excelisfun Old School Method
7. (05:14) excelisfun LET Function Method. Big Array Formula.
8. (10:13) Mr Excel Shouts Out!!!!
9. (10:40) Concluding remarks. Mr Excel Surprised by LET formula!!!
10. (11:44) Closing Batman Duel Part in Song