The simplest use of the FORMULATEXT function is straightforward formula auditing.

Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column. Excel's myriad formatting tools let you add colors, formulas and borders almost anywhere in a worksheet. You can ...

I'm importing a lot of comma delimited text files into Excel - because they all have the exact same formatting, is there a way to tell Excel to process all of them the same way? (ie, what fields to ...