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

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.