Do Anything with Text in Formulas
Same as Excel's built-in MID function, but searches from right to left.
Returns the number of characters specified from a text string, starting from the position specified, counting from the right.
itMIDR is intended to be as similar as possible to Excel's built-in MID function, while searching from right to left. For much more powerful and versatile searching, see itSEARCH.
|text||Required. The text from which to get the desired characters.|
|start_num||Required. The position of the first character in text to be returned, counting from the right.|
|num_chars||Required. The number of characters to return, counting from right to left.|
|=itMIDR("abcdefg",2,3)||Return the 3 characters in "abcdefg" that end with the 2nd-to-last character in "abcdefg".||def|
PrecisionCalc Home Page