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

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.