The simplest use of the FORMULATEXT function is straightforward formula auditing.
Instead of selecting all errors, press F5 > Alt+S > C > Enter to highlight all constants—numbers, text, and symbols that aren ...