Making the characters uppercase and lowercase

By using UPPER() function, you convert all the text in a cell to uppercase.

By using LOWER() function, you convert all the text in a cell to lowercase.

Moreover, by using PROPER() function, you convert the first characters of words in a cell to uppercase.

At the last three functions, you control  three cell index by using nested IF( ). According to the result, you convert the letters in other cells  to uppercase or to lowercase by using UPPER(), LOWER() and PROPER() functions.

Related Trainings

Error Handling

Error Handling

Correcting value errors.


Most Popular Movies

Most Popular Movies

Getting produced year of popular films of the IMDB from unformatted title information with year. Also calculating votes ...


Vacation Day Calculator

Vacation Day Calculator

Calculate vacation days based on years worked and other conditions