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
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:
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
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
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).
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.