Page 10 of 23PREVNEXT

Use formulas to edit, correct, and proofread text

Function name Used to
LEN count the number of characters in a cell
CONCATENATE combine information from two cells into one cell
EXACT compare two cells
Function names summarize long formulas.

Instead of counting the number of letters in a cell, retyping to combine information from two cells into one, or proofreading to compare cell contents, let Excel do the work for you by using formulas. In the practice session, you'll have a chance to use the formulas and functions you've learned about.

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

Page 10 of 23PREVNEXT