Reply to comment
(Text t, Text d)
Returns the left part of a text value up to but not including the first 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.
Left("abc/def",";/,") returns "abc" Left("Michael Smith", " ") returns "Michael"