is the column number in table_array from which the matching value should be returned. The first column of values in the table is column 1
is text that represents a date in a Microsoft Excel date format, between 1/1/1900 (Windows) or 1/1/1904 (Macintosh) and 12/31/9999 ...
is the cell or a single range of cells for which you want the row number; if omitted, returns the cell containing the ROW ...
is the cell or range of contiguous cells for which you want the column number. If omitted, the cell containing the COLUMN ...
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) ...