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

This is where Excel’s text functions, like FIND and LEFT, come into play, along with the VALUE function to convert text to numbers and the SUM function to add them all up. Prime Day may have closed ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.