NotLeft
Returns what remains after excluding the left part of a text value.
Variants
NotLeft(Text text, Text delimiter)
Returns what remains after excluding the left part of a text value up to and including the first occurrence of a delimiter value.
Parameters
- text
- The text string that contains the characters you want to extract.
- delimiter
- The delimiter string.
Returns
Text
Remarks
If the text does not include the delimiter, a blank value is returned.
Examples
NotLeft("Jane Smith", " ")returns the text value "Smith".NotLeft("type-20A", "-")returns the text value "20A".NotLeft("type-20A", "/")returns a blank value.NotLeft("type-20A", "/-")returns a blank value.
NotLeft(Text text, Numeric number)
Returns what remains after excluding the leftmost number of characters from the text argument.
Parameters
- text
- The text string that contains the characters you want to extract.
- number
- Specifies the number of characters you want to skip before returning the remaining characters.
Returns
Text
Examples
NotLeft("typeABC", 4)returns "ABC".