PrecisionCalc
inspector
text
Do Anything with Text in Formulas
itMIDR
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.
Syntax
itMIDR(text,start_num,num_chars)
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. |
Examples
Formula | Description | Result |
=itMIDR("abcdefg",2,3) | Return the 3 characters in "abcdefg" that end with the 2nd-to-last character in "abcdefg". | def |