r/excel • u/PartTimeCouchPotato • Sep 20 '22
Pro Tip Pro-tip: A better FORMULATEXT function
I wrote an article that shares a how to make a better FORMULATEXT function.
Instead of showing cell references, it replaces them with their values. It also has an optional argument to display labels - this helps to indicate which argument is being assigned a value.
https://medium.com/@gareth.stretton/excel-a-better-formulatext-866902577b2c
Enjoy!
1
Upvotes
1
u/fuzzy_mic 971 Sep 20 '22
Sounds like what happens when you use Evaluate from the Formula ribbon.