Tag: UPPER

By Posted on Posted in Excel Funtions, Excel Tricks No Comments Tagged with , , , , ,

This sheet can calculate the value of your name or any word by summing every letter in alphabetical order. Here I have created a box to input a word. I have put this formula =LEN(B2) to calculate the length of the …

Lesson#59: If A=1, Z=26 then calculate the value of your name Read more »

By Posted on Posted in Excel Funtions No Comments Tagged with , , ,

The UPPER function converts a text string to all uppercase letters. The syntax of this function is UPPER(text).   An example of the UPPER function is shown in the pictures above. The LOWER function converts a text string to all lowercase letters. The …

Lesson#32: UPPER, LOWER, PROPER, TRIM Text functions in Excel Read more »