SEARCH Function

Advanced Excel Exercises with Solutions PDF

In this article, you will find advanced Excel exercises with solutions in PDF format. You need to possess advanced Excel knowledge to solve these ...

How to Use Line Break as Delimiter in Excel Text to Columns

Sometimes, you need to use a line break in a particular cell. This line break can be used as the delimiter in the Excel text-to-column feature. That ...

How to Convert Text to Columns Without Overwriting in Excel

Frequently, we need to convert text to columns in Excel in our day-to-day tasks. In fact, Microsoft Excel is an excellent tool to perform this task. ...

How to Change Semicolon to Comma in Excel (6 Effective Ways)

Preparing Excel worksheet and have given semicolon mistakenly instead of a comma in your texts? Want to change semicolon to comma but find it ...

How to Remove Comma Between Numbers in Excel

Commas have several uses while dealing with spreadsheets in Excel. For example, they improve the readability of numbers. However, there may be ...

How to Create a Search Box in Excel Without VBA (2 Easy Ways)

We may think that creating a Search Box in Excel without VBA is impossible. But it’s not true. In this article, we will learn how to create a Search ...

How to Remove Comma from Currency in Excel (6 Handy Tricks)

Does comma in numbers in an Excel worksheet bother you? Do you want to clean up your data by removing the comma from the number describing currency? ...

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 Cut Text Using Formula in Excel (6 Simple Methods)

Sometimes we create a dataset with all the pieces of information in a single cell. But while making the final report we need to cut some text from ...

How to Count Filtered Rows with Criteria in Excel (5 Easy Ways)

In Excel, the Filter is a very powerful tool to fetch specific data from a large dataset. Along with filtering, we sometimes need to count those ...

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 (4 Easy Methods)

While working with a huge set of data in Microsoft Excel, Search Box is an important tool to find particular data. A Search Box makes an Excel ...

How to Reverse Names in Excel (5 Handy Methods)

Do you want to learn how to reverse names in Excel with some exciting formulas? This article is for you. Here we discussed 5 simple and handy methods ...

How to Select Highlighted Cells in Excel (4 Easy Techniques)

An organized and neat presentation is always a priority especially when we work with a large dataset. This is why most excel users prefer to ...

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 ...

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo