Version: 2.2.1 +
The formula 'Mid' returns the characters from the middle of a text string, given a starting position and length.
Text: this is the text string from which you want to extract the letters.
Start_num: this is the position of the first character you want to extract, The first character in 'Text' is 0.
Num_chars: this specifies how many characters to return from 'Text'.
In the following example you can see how the formula 'Mid' works.
Text: Dear Mr.
Right: The formula 'Right' returns the specified number of characters from the end of a text string.
Left: The formula 'Left' returns the specified number of characters from the start of a text string.
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.