Here's our Microsoft Office Tip for.. November 1, 2005
Click Here to see a complete list of all of our previously released Tips!
More on Replacing Data
In a previous tip, we showed you how to replace data using the Edit menu's Replace command. However, choosing Replace All can have unexpected and destructive results because you could write over data you didn't intend to change. If you choose this method for changing information on a worksheet, you could eradicate data that you can't see.
Of course, replacing each item one at a time can be a real nuisance. So, here's some protection when you use Replace All. Save your file with a different name before you try a global Replace. Then you'll at least have a backup in case you do delete something you need.