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; “T3” ...

How to add Text to a Cell in Excel using Formula. Adding a text to a cell requires the use of the ampersand operator, the CONCAT function, or the LEFT, RIGHT, and LEN functions.