Manually finding and replacing parts of text can be exceedingly tedious for lengthy Excel spreadsheets. Luckily, Microsoft included a couple of useful tools for locating text parts and replacing them ...

Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...

The Alt+Enter shortcut isn't limited to new formulas you write—you can go back and clean up any messy formulas at any time.