SEARCH Function

How to Create a Filtering Search Box for Your Excel Data (5 Ways)

When there is lots of data then if you have a Filtering Search Box for your Excel data then it will be very helpful for you to find any data within a ...

How to Create Search Box in Excel with Conditional Formatting

Looking for ways to know how to create a search box in Excel with Conditional Formatting? We can create a search box in Excel in different ways. ...

How to Create a Search Box in Excel for Multiple Sheets (2 Ways)

This article illustrates how to create a search box in excel for multiple sheets. Assume you have 20 sheets in your workbook. Now you need to search ...

How to Make Yes Green and No Red in Excel (8 Examples)

When dealing with large amounts of data, formatting the data in Excel in specific ways can improve readability. If you are looking for some special ...

How to Insert Character Between Text in Excel (5 Easy Methods)

If you want to insert character between text in Excel, this article is for you. Here, we will walk you through 5 easy and effective methods to do the ...

Search for Question Mark in Excel (4 Suitable Methods)

Microsoft Excel has several options to search for a specific text or character. In this article, we will show how to search for Question Mark in ...

How to Separate City and State in Excel (3 Effective Methods)

Usually, an address consists of house number, street, city and state names, zip, etc. Typically, they are segmented by a symbol like Comma(,). For ...

How to Calculate Ratio Percentage in Excel (4 Easy Methods)

With ratio, we can visualize the relative size between two or more variables or numbers, In Excel, we also have to deal with ratios a lot. How can we ...

Convert Fraction to Decimal in Excel (2 Simple Approaches)

When working with numbers and calculations, it is a common thing to get fractions or decimals as results. Sometimes it happens that, the result is ...

How to Subtract Two Columns in Excel (5 Easy Methods)

Subtraction is the process of finding the difference between two numbers or integers. If we go back to our old school memory, we used to put a minus ...

How to Separate Date from Text in Excel (4 Methods)

In this article, I will discuss how you can separate the date from text strings in Microsoft Excel. While working with excel, often we receive ...

Calculate Conditional Weighted Average with Multiple Conditions in Excel

This tutorial will demonstrate the methods to calculate conditional weighted average with multiple conditions in Excel. While calculating the ...

Separate First and Last Name with Space Using Excel Formula (3 Ways)

In Microsoft Excel often we need to separate first and last names. Separating first name and last name can be done with flash fill and formulas. In ...

How to Create a Searchable Database in Excel (2 Quick Tricks)

While working with large Microsoft Excel, sometimes we need to search for some data. Creating a searchable database in Excel is an easy task. This is ...

How to Split Text by Number of Characters in Excel (7 Ways)

This tutorial demonstrates how to split text by a number of characters in excel. When working with a dataset in Excel, the format can vary depending ...

ExcelDemy
Logo