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

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Excel's "Find and Replace" feature will search an entire spreadsheet or selected cells for your specified text. Excel also offer a "Replace" function.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

Functions of Different Categories in Excel. To analyze your company's payroll expenditures, you might create an Excel spreadsheet and use some of the functions in the Financial or Math ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...