Function TRIMGRANGE

The TRIM function removes extra blank characters, we all know this by now, and TRIMRANGE, as its name suggests, is used to remove empty values from a selected range of data. In addition, it is possible to specify whether their removal takes place in rows or columns and in which order. It is well combined with the SORT and UNIQUE functions, and in the following text you will see how to apply it in practice.

Uppercase and lowercase letters

Excel has a large number of conversion functions. This text will show the ones used to convert lowercase letters into uppercase, uppercase to lowercase, and capitalize the initial letters of each word in the given cell. We will also mention two features that are used to clean the text, either by removing excessive spaces or unprintable characters that often exist in old applications and end up in the table when retreiving data.