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

 

 

PrecisionCalc Home Page