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

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER () and TEXTBEFORE () in this tutorial.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

Modern Excel functions like XLOOKUP, TEXTJOIN, and dynamic arrays offer faster, more versatile, and error-resistant alternatives to outdated tools such as VLOOKUP, CONCAT, and OFFSET.

The Sort Excel function is a powerful tool for organizing and arranging your data in a meaningful order. Whether you need to sort numbers, text, or dates, this function has you covered.

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.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

Microsoft is adding a COPILOT function to Excel, letting you use natural language prompts inside formulas to analyze, summarize, and categorize data.