Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

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

Perhaps Excel will create a built-in function to convert text to sentence case in the future, but until then, a formula will work. If you would like to follow along in building this formula, you can ...