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

Find the data you need in an Excel sheet more easily with these functions.

It is very easy to dissect the contents of a cell in Excel using the functions LEFT, MID, and RIGHT. All three functions are easy to learn.

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

The first part of the formula is =UPPER (LEFT (T3,1)). It capitalizes the first letter of the first word in the sentence. The LEFT function instructs Excel to go to the far left of the text string; ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

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.

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.

A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets.