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.

MIN

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