SUBST

Returns a substring of a specified string with a specified length beginning at a specified character.

Syntax

SUBST(String, Beginning, Length)

String is the string from which you want to return the substring. Beginning is the number of the character in String that should be the first character of the substring. Length is the length of the substring. The first argument must be a string or a formula that returns a string. The second two arguments must be integers. If non-integer values are specified in the second two arguments, they are rounded to the nearest integer.

Example

This example returns 'IACTA':

SUBST('Alea IACTA EST', 6, 5)