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

I have created a workbook with an example of using LEFT, MID, and RIGHT. Click here to access the workbook and watch the accompanying video at the bottom of the page. Note that the content that ...

Excel has over 475 formulas in its Functions Library, ... Common uses of this function are; for example, ... LEFT & LEN. Use this function to separate the states from the ZIP codes.

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 ...