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

Excel doesn't offer a one-click solution if you need text in sentence case (where only the first letter of the sentence is capitalized). But don’t worry! You can create a custom formula using the LEFT ...

Navigate to the "Number" group within the "Home" tab in Excel. Click the small arrow beside the "Number Format" box. Click "Text" to convert your cells to text formatting.