Our Formula Function Reference
Formula Function Reference
NotRight - Text
(Text t, Text d)
Returns what remains after excluding the right part of a text value starting at the last occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters. If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter.
NotRight("abc/ def"," ;/,") returns "abc" NotRight("Michael Wissner", " ") returns "Michael"