Microsoft Office Tutorials and References
In Depth Information
What Makes a Good Utility?
Figure 16-1 shows the Text Tools Utility dialog box.
Figure 16-1: Use the Text Tools utility to change the case of selected text.
The Text Tools utility is available on the CD-ROM that accompanies this topic. It’s a
stand-alone version of the tool that’s included with the Power Utility Pak. The file,
named text tools.xlam , is a standard Excel add-in. When installed, it adds a new
command to the Ribbon: Home➜Utilities➜Text Tools. The VBA project isn’t protected
with a password, so you can examine the code to see how it works, or make changes to
better suit your needs.
Background for Text Tools
Excel has many worksheet functions that can manipulate text strings in useful ways. For example,
you can make the text in a cell uppercase (UPPER), add characters to text (CONCATENATE),
remove spaces (TRIM), and so on. But to perform any of these operations, you need to write
formulas, copy them, convert the formulas to values, and then paste the values over the original
text. In other words, Excel doesn’t make modifying text particularly easy. Wouldn’t it be nice if
Excel had some text manipulation tools that didn’t require formulas?
By the way, many good utility ideas come from statements that begin, “Wouldn’t it be nice if . . .?”