FIND Function

How to Remove Spaces in Excel: With Formula, VBA & Power Query

In Microsoft Excel, there are several effective methods available to remove all sorts of unwanted spaces. You’ll get to know all possible and ...

How to Reference Worksheet Name in Formula in Excel (3 Easy Ways)

Today I will be showing how to reference a worksheet name in formula in Excel. We may know how to work with more than one worksheet in Excel. But ...

COUNTIF Cell That Contains a Specific Text in Excel (Case-Sensitive and Insensitive)

Today I will be showing how you can use COUNTIF to count cell that contains a specific text within it. I will show both case-insensitive and ...

How to Sort by Last Name in Excel (4 Methods)

If you work with datasets in Excel, you will often need to sort these datasets by name. Sometimes. You may need to sort the dataset based on your ...

How to use ISNA function in Excel (4 Examples)

Excel provides several information functions to provide you the necessary information and help you perform your desired tasks easily and swiftly. ...

How to use TRIM function in Excel (7 Examples)

Excel provides several text functions to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Use RIGHT Function in Excel (With 6 Easy Examples)

RIGHT is another popular function in MS Excel that is used to get the last character or characters in a text string, based on the specific number of ...

How to Use REPLACE Function in Excel (3 Suitable Examples)

In Microsoft Excel, the REPLACE function is generally used to replace or substitute a text. The replacement is based on its starting position and ...

How to Use FIND Function in Excel (7 Suitable Examples)

In Microsoft Excel, the FIND function is generally used to extract the position of a defined text in a cell containing a text string. In this ...

How to Use LEN Function in Excel (Formula and VBA Code)

Excel provides a function called LEN for counting letters, numbers, characters, and all spaces. LEN is a short form of LENGTH. LEN function is used ...

How to Use DATEVALUE Function in Excel (6 Suitable Examples)

DATEVALUE function in Microsoft Excel is generally used to convert a text date into the date-time number codes. In this article, you’ll get to learn ...

How Do I Count Cells with Text in Excel (5 Methods)

You need to count how many cells contain text within your data set for many different operations. Today we will show you how to count cells with text ...

How to Split One Cell into Two in Excel (5 Useful Methods)

When you import data from a database or any other sources, you have to split cell one into two or more in such situations. In this tutorial, I’m ...

If Cell Contain Word Then Assign Value in Excel (4 Formulas)

If you want to assign value to a cell based on a certain word in another cell then you'll need to build a formula because Excel doesn't provide a ...

How to Separate Numbers in Excel Using Formula (5 Ways)

Sometimes we may need to separate or get only numbers from any text and number combined input. Without doing this manually Excel provides various ...

ExcelDemy
Logo