Excel Tips No 1 : Change Sentence Case in Excel

This free microsoft excel tips no 1 is telling to change Sentence Case in Excel to be title case or Upper/lower case in our spread sheet

You can use this function

=Upper(cell address) : Change case in the adreesed cell to CAPITAL CASE
example : =upper(C3) --> Change case in cell C3 to CAPITAL CASE

=proper(cell address) : Change case in the adreesed cell to Sentence Case
example : =proper(C3) --> Change case in cell C3 to Sentence Case

=lower(cell address) : Change case in the adreesed cell to lower case
example : =lower(C3) --> Change case in cell C3 to lower case



I hope this tips can help you