There are times text needs to be converted to lower case, proper case, or upper case for consistency sake. Excel provides functions to easily convert text in these cases.
However, Excel does not convert text to sentence case — the first letter only is capitalized. Using a combination of functions will easily convert text to sentence case.
The formula to convert the text in A1 is:
=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
For examples, see the following:
Next week will continue with more useful text functions.
I Teach Accounting Information Systems 