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