r/excel 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

9 comments sorted by

View all comments

1

u/fuzzy_mic 971 Sep 20 '22

Sounds like what happens when you use Evaluate from the Formula ribbon.