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

iPhone vs Samsung

iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.


iPhone vs Samsung

iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.


Practice: IF Functions 6 - Students

Practice: IF Functions 6 - Students

Making more practice by using IF() function.