The Substitute function in Microsoft Excel replaces a specific text in a text string with a different text. The Replace function replaces part of a text string based on the number of characters ...

Formulas Functions are preconfigured formulas used in Microsoft Excel and Apple Numbers. Apple Numbers was updated in 2009, which increased the total number of functions available.

Q. I have an Excel spreadsheet that contains errors because some of the numbers that are part of the calculations are blank or zero. Is there a way to have Excel automatically return something instead ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.