MAX

The MAX function finds the maximum value in a specified range or series of numbers.

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.

MIN

The MIN function finds the minimum value in a specified range or series of numbers.