Convert Text to a Formula in Excel | The CRAZY method for tough Excel problems.

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Blog post ★
https://exceloffthegrid.com/convert-s...

★ About this video ★
We can convert text to a range using the INDIRECT function, so there has got to be a function to convert text to a formula... right?

Well... no... yes, kind of!

So let's find out how to convert Text to a formula in Excel.

0:00 Introduction
0:24 EVALUATE function
1:24 EVALUATE/LAMBDA combination
3:09 How to automate Excel
3:24 Use case
4:45 VBA User Defined Function
5:58 Wrap-up

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel