FIND Function Archives

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

Nov 30, 2021 Excel Formulas

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)

Nov 15, 2021 Excel Formulas

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)

Oct 24, 2021 Excel Formulas

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)

Nov 1, 2021 Excel Basics

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 Sort by Last Name in Excel (4 Methods)

How to use ISNA function in Excel (4 Examples)

Nov 11, 2021 Excel Functions

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)

Nov 11, 2021 Excel Functions

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)

Nov 11, 2021 Excel Formulas

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)

Nov 14, 2021 Excel Functions

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)

Nov 14, 2021 Excel Functions

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)

Nov 14, 2021 Excel Formulas

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)

Nov 18, 2021 Excel Functions

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)

Nov 11, 2021 Excel Formulas

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)

Nov 15, 2021 Advanced Excel

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)

Nov 15, 2021 Excel 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)

Oct 19, 2021 Excel Formulas

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