TRIM

The TRIM function removes unnecessary spaces in a string. Use it together with the PROPER function to clean your data.

PROPER

The function PROPER returns a string with a uppercase letter at the beginning of each word.