To clean up and transform text data, we use text transformation formulas such as LEFT, RIGHT, UPPER, LOWER, PROPER, SUBSTITUTE, TRIM, CONCATENATE and LEN. They make it easy to manipulate character strings such as names, addresses and telephone numbers. It's also possible to remove unwanted characters such as spaces, hyphens or parentheses.