Excel formulas do more than make it easy to work with numbers. You can also use formulas to correct or rearrange text without retyping. This is especially handy after you've imported a large text file that needs to be cleaned up. In this course you'll learn how to use formulas to add or remove capitals, delete extra spaces, combine information from two cells into one, and separate some of the information from one cell into another. You'll also learn how to compare cell contents without proofreading.

To learn more about this course, you can read the overview in the center of this page or the detailed table of contents in the left column.

Click the Next button to start the first lesson.

You should complete the course Audio course: Get to know Excel: Enter formulas, or you should already be familiar with Excel formulas, functions, cell references, and function arguments.