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)