Using the function in a worksheet

When you enter a formula that uses the RemoveVowels function, Excel executes the code to get the value. Here's an example of how you would use the function in a formula:


See Figure 10-1 for examples of this function in action. The formulas are in column B, and they use the text in column A as their arguments. As you can see, the function returns the single argument, but with the vowels removed.




Every good boy doei fine.

vry fd by di frt.


anUdisesLablishmEnLafi jniim

iiLdsstblsiim nlmsm


MKncsflft ¿xeel

Men ft ncl


abedeighij* Irmvjpqrtfu™ E



A13 liure (jo communi [die.

f Er t cinmncl.


This sentence tiat rw vowels.

Ths intnc h5 n vufls.



< ► ► SlltKll


Figure 10-1: Using a custom function in a worksheet formula.

Figure 10-1: Using a custom function in a worksheet formula.

Actually, the function works pretty much like any built-in worksheet function. You can insert it in a formula by choosing Formulas Function Library Insert Function or by clicking the Insert Function Wizard icon to the left of the formula bar. Either of these actions displays the Insert Function dialog box. In the Insert Function dialog box, your custom functions are located, by default, in the User Defined category.

You can also nest custom functions and combine them with other elements in your formulas. For example, the following formula nests the RemoveVowels function inside Excel's UPPER function. The result is the original string (sans vowels), converted to uppercase.


0 0

Post a comment