Page 1 of 23PREVNEXT

Use formulas to edit, correct, and proofread text

Use formulas instead of retyping
Learn how to save time by using formulas instead of retyping to work with text in Microsoft® Excel.

About this course

This course includes:

  • Three self-paced lessons and three practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to use formulas to:

  • Change text to initial capitals, all capitals, and no capitals.
  • Delete extra spaces in a cell.
  • Count characters in a cell.
  • Combine information from two cells into one cell.
  • Compare cell contents.
  • Separate part of the information from one cell into another cell.

Before you begin

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.


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.

Page 1 of 23PREVNEXT