The simplest use of the FORMULATEXT function is straightforward formula auditing.
To use this feature, first, select the range you want to search, or select any cell to search the whole worksheet. The fastest method is to press F5 (or Ctrl+G) to open the Go To Dialog box, then ...
Speed up Excel cleanup with smarter wildcards. We compare three methods and show start or end matching your lists actually need.