SEARCH Function

### How to Use MID Function in Excel (5 Ideal Examples)

While working in Excel, we often need to extract a specific number of characters from a cell. This can be achieved by both the LEFT and the RIGHT ...

### How to Use LEFT Function in Excel (5 Suitable 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 LEN Function in Excel

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

### How to Use FILTER Function in Excel (10 Ideal Examples)

Excel 365 provides us with a powerful function for automatically filtering our datasets, named the FILTER function. It makes our task easier by using ...

### How to Sort by Date and Time in Excel (4 Useful Methods)

Sorting implies rearranging data for getting a better visual presentation of your dataset. It is such a powerful tool that can organize text, ...

### How to Filter Multiple Rows in Excel (11 Suitable Approaches)

In our practical scenario with Microsoft Excel, we have to filter columns as well as rows from a large range of data for analysis. In this article, ...

### How to Filter with Multiple Criteria in Excel (4 Easy Ways)

Today I will be showing you how Excel filter multiple criteria of some matching data using the FILTER function of Excel. Before going to the main ...

### How to Filter Data Based on Cell Value in Excel (6 Easy Methods)

Sometimes data in a worksheet is too complicated or crammed that we face difficulties to find out desired data. Retrieving data from a dataset ...

### How to Compare Two Strings for Similarity In Excel

In this tutorial, I am going to show you 6 easy methods on how to compare two strings for similarity in excel. You can use these methods even in ...

### How to Find Similar Text in Two Columns in Excel (3 Easy Ways)

Depending on the circumstances you may need to find similar text within two columns in Excel. Today, we are going to show you how to find similar ...

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

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

### How to Assign Value If Cell Contains Word in Excel (4 Easy Ways)

If you want to assign a 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 Extract Only Numbers from Excel Cell (7 Easy Ways)

Although Microsoft has not provided a straight formula or syntax to extract only numbers from the Excel cell, we can incorporate a wide range of ...

### How to Return Value in Excel If Cell Contains Text from List

If you have a list of text and want to search cells and return values based on the list, you'll need to build a formula because Excel doesn't provide ...

### How to Separate Text and Numbers in Excel (6 Suitable Ways)

We often have to separate text and numbers from some data in Excel. Today I will be showing 4 easy ways how you can accomplish that conveniently. ...