Excel's "Find and Replace" feature will search an entire spreadsheet or selected cells for your specified text. Excel also offer a "Replace" function.

Substitute and Replace functions are text functions. We explain how to use the Substitute and Replace functions in Microsoft Excel.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Q. When I’m working in Excel, I sometimes have trouble remembering a formula. Is there an instant crib sheet I can refer to? I know I can look it up in Help , but that’s such a slow process. A. Yes, ...

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.