Here are a few of my favourites that I have used in the past:This formula extracts the leftmost characters from the "DE:Client" field up to the first space character, or more simply, extract the first word from a text field.LEFT({DE:Client}, NUMBER(SEARCH(" ", {DE:Client},0)))Here's how it works:SEA...