hi all
i have some very long and complex formulas in my Excel workbook and it's extremely difficult to track and debug some of them.
is there a way to define components of these formulas, such as "VLOOKUP(**,***,**,0) as text so that they appear as text in the formula bar but still serve their purpose?
thanks
Bookmarks