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

How to use the Find function In Excel In this tutorial, we want to find the character of ‘ Pig.’ We are going to click the cell where we want to find the character. Then type =Find; bracket.

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.

This tutorial will explain how to find a value in an Excel column using the Find function in VBA. Excel will highlight all of the cells that correspond to your search. How to search data using the ...

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.

Identify the Column with Relevant Data Identify the column whose data you want Excel to find in a different array. With this example, this column will list product codes. The different array will ...

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