is the existing text you want to replace. If the case of Old_text does not match the case of text, SUBSTITUTE will not replace the text
is the character number in Within_text, counting from the left, at which you want to start searching. If omitted, 1 is used ...
is the column number in table_array from which the matching value should be returned. The first column of values in the table ...
is the condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the ...
is the error value for which you want the identifying number, and can be an actual error value or a reference to a cell containing ...
is the existing text you want to replace. If the case of Old_text does not match the case of text, SUBSTITUTE will not replace ...
is the first array or range of data and can be numbers or names, arrays, or references that contain numbers (blanks are ignored) ...
is the name of the code resource in Microsoft Excel for the Macintosh, or the resource ID number (this number must not be ...
is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero or omitted, to ...
is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero to the nearest ...