Part II: Working with Formulas and Functions
FIGURE 11.2
Using the TEXTJOIN function
Setting text to sentence case
Excel provides three useful functions to change the text to upper, lower, or proper case. As
you can see in rows 6, 7, and 8 illustrated in Figure 11.3, these functions require nothing more
than a pointer to the text that you want to be converted. As you might guess, the UPPER
function converts text to all uppercase, the LOWER function converts text to all lowercase, and
the PROPER function converts text to title case (the first letter of every word is capitalized).
FIGURE 11.3
Converting text into upper, lower, proper, and sentence case
What Excel lacks is a function to convert text to sentence case (where only the first letter
of the first word is capitalized). But as you can see in Figure 11.3, you can use the following
formula to force text into sentence case:
=UPPER(LEFT(C4,1))&LOWER(RIGHT(C4,LEN(C4)-1))
