Using the find and replace ability in Microsoft Excel 2010, you can quickly replace duplicate letters, words and cells in a spreadsheet document of any size. The following also applies to previous ...

This truly GLOBAL find and replace will help. Say that you have hundreds of similar Excel workbooks in a folder and you need to globally change “2009 Budget” to “2010 Budget” in all of the workbooks.