The first part of the formula is =UPPER (LEFT (T3,1)). It capitalizes the first letter of the first word in the sentence. The LEFT function instructs Excel to go to the far left of the text string; ...

Ref2, which is optional, is for any additional ranges of cells. You can have up to 252 ranges. [k], which is optional, is used with function_nums like LARGE, SMALL, PERCENTILE, and others that require ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.