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 ...

First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...