Microsoft Office Tutorials and References

In Depth Information

**Using Excel Functions**

TRIM:
The TRIM function removes any extra

spaces but leaves one space between each

word. The syntax is =TRIM(
cell address
).

REPT:
The REPT function allows you to

repeat characters a specified number of

times. The syntax is =REPT(
what characters,

number of times to repeat
). If cell G5 had a

value of 12, then if you enter =REPT(“*”, G5)

the answer cell would show 12 asterisks.

You can specify more than one character

such as */ or <>.

Getting Help with Excel

Functions

With each Excel function having a different syntax,

it becomes almost impossible to remember the

syntax of each function. You’ve already seen that

when you begin typing the function and the open

parenthesis, Excel displays a function ScreenTip to

help you, but you can get even more help with

functions by using the Insert Function feature. Just

follow these steps:

Figure 9-22

Selecting a function from the Insert Function box.

Enter Function Description

If you don’t know the name of the function

you want, in the search box, type a

description of what you want to do, then click Go.

Excel displays a list of possible functions to

meet your needs.

1.
Click the cell where you want to enter a

function.

2.
Choose Formulas>Function Library>Insert

Function. Excel automatically inserts the

equals (=) sign in your selected cell and the

Insert Function dialog box opens.

5.
Click OK, which opens the Function

Arguments dialog box. In the selected cell,

Excel inserts the Function name and the

parentheses.

3.
Click the Or Select a Category arrow and

choose a function category. If you don’t know

the category, choose All (see Figure 9-22).

Optional Arguments

Since some function arguments are optional,

in the Function Arguments dialog box, Excel

lists the required arguments in bold.

4.
Choose the function you want. The function

syntax and a description of the function

display under the function list.