Page 2 of 23PREVNEXT

Use formulas to edit, correct, and proofread text

Function name Used to
PROPER capitalize the first letter of each word in a cell
LOWER change text to no capitals
UPPER change text to all capitals
TRIM delete extra spaces between text, as well as leading and trailing spaces in a cell
Function names express long formulas quickly.

You don't have to retype to capitalize words, and you don't have to delete extra spaces by hand, which is especially good to know when you're editing lots and lots of text, in lots of different cells. In this lesson you'll see how to clean up information quickly by typing a prewritten formula called a function, and then applying it to many cells. In the practice session at the end of the lesson, you'll have a chance to use the formulas and functions you've learned.

To continue reading this lesson on your own, click the Next button.

Page 2 of 23PREVNEXT