O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Replacing Data

The Edit Replace command lets you quickly locate and replace numbers, text, data formats, and special characters. Suppose you have text that you entered incorrectly or that has changed throughout a large worksheet. You can use the Edit Replace command to have Excel search for and replace all occurrences of the incorrect information with the correct information. You can find and replace data in three ways:

  • Replace the first occurrence of the data

  • Replace specific occurrences of the data

  • Replace all occurrences of the data

In the next To Do exercise, you search for the first instance of the word cover and replace it with the word volume.

To Do: Replace Data

1.
Choose Edit, Replace. Excel opens the Find and Replace dialog box.
2.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required