Changing case in Excel
Excel Functions December 9th, 2007
Unlike microsoft word, Excel does not have an option wherein you could Format text to change case. But don’t worry, excel does have “change case” functions, so in case you have incorrectly typed everything in one case than another, you won’t need to rekey them.
To change case you can use upper, lower or proper formula.
Upper would change everything to upper case. Similarly lower would put them in lower case.Proper case would capitalise the first letter, keeping the rest in lower case.
Suppose you wish to change the contents of column A to lower case instead of upper, you can do that as follows:
Popularity: 10%
How about Title Case? I have’t found it in any formula. At the moment, I copy-paste selected data to Ms. Word 2003, changing it by “Format, Change Case, Title Case” and then copy-paste again to Excel, not so practice huh?! =(
Hi,
If you read the last line of our post, you can use “Proper Case” for changing the case to a word having its first letter as a majuscule.
Regards
Once again thanks for this tip