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

The Find and FindB functions count the number of characters of a text. We will explain how to use the Find and FindB functions in Excel.

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

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

How to Capitalize Text in Excel Need to make a bold statement by converting everything to upper case? Excel’s UPPER function has your back.

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

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

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.

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.

Perhaps Excel will create a built-in function to convert text to sentence case in the future, but until then, a formula will work. If you would like to follow along in building this formula, you can ...