I am wondering why these functions are not available in Word, but Excel?
Don’t make me wrong. I like these functions. Nevertheless I am not a big fan (nor a small fan) of using Excel as word processor. Whenever possible, use Excel to handle data; Word to handle words. That are what the softwares designed for!?
But the fact is, many people use Excel in their own ways and can somehow create forms and documents with Excel even better than they do the same in Word. Agree? I would say: Excel is so great that it handles not just numbers but texts equally effective.
Well, too much personal talks… let’s go back to the subject: UPPER, lower, Proper.
The syntax is simple.
=UPPER(text) 'change all letters to UPPER CASE =LOWER(text) 'change all letters to lower case =PROPER(text) 'Capitalize the first letter of each word in a text string.
All of them require only one argument. The argument could be a direct text enclosed with “”, a reference, or a formula result. They are quite easy to follow. Nevertheless, he meaning of “each word” described above for PROPER is a bit tricky. It means the first word and any word that follow any character other than a letter.
Again and again, a picture tells more:
As simple as that. 🙂
How to do the same in Word?
To capitalize all letters is easy in Word. Just select the texts you want to capitalize, right click–> Font–> Check the “All caps”.
Here’s an example:
Wait… How to do lower and Proper in Word?
Honestly, I don’t know…
If you know, please share in comments. 🙂