SEARCH Function Archives - Page 6 of 8

How to Extract Text from a Cell in Excel (5 ways)

May 16, 2022 Excel Formulas 3

Extracting text from a cell is one of the most common uses of Microsoft Excel. You may need to extract text from the beginning, middle, or from a ...

How to Remove Text After Character in Excel (3 Ways)

May 16, 2022 Excel Formulas

While working with a large dataset, sometimes you may need to remove some certain part of the data. To do this manually is really time consuming and ...

Subtraction Formula in Excel (7 ways)

Jun 6, 2022 Excel Basics

We all know basic subtraction. It is mainly finding differences between two or more values. This article will show you subtraction formula in Excel ...

How to Find Value In Range in Excel (3 Methods)

May 14, 2022 Excel Formulas

Circumstances may demand you to find value from a range. Finding, retrieving are common operations in Excel. Today we will show you how to find value ...

How to Find Text in Cell in Excel

May 14, 2022 Excel Formulas

While working in Excel, we often have to search for a specific text within another text. Today I will be showing how to find a text within another ...

How to Find a Character in String in Excel

May 14, 2022 Excel Formulas

In Excel, we can find a specific character within a string. Several built-in functions help us finding the character. Today we are going to show you ...

How to Find If A Range of Cells Contains Specific Text in Excel (4 Methods)

May 14, 2022 Excel Formulas

While handling a large database you may need to find a specific text from the database. Excel has some functions by which you can easily do that. ...

Excel Search for Text in Range (11 Quick Methods)

May 14, 2022 Excel Formulas

In Microsoft Excel, there are numerous methods available to search for text in a range of cells or an array. You can search for a text value and ...

How to Find If Cell Contains Specific Text in Excel

May 14, 2022 Excel Formulas

In Excel, circumstances may demand checking whether a cell contains a specific text or not. Today we are going to show you how to check if a cell ...

How to Enter Sequential Dates Across Multiple Sheets in Excel

May 12, 2022 Excel Formulas

Today I will be showing how to enter sequential dates across multiple sheets in Excel. Up till now, we have learned to enter dates in Excel. We ...

How to Use Partial VLOOKUP in Excel(3 or More Ways)

Feb 26, 2022 Excel Formulas

There may arise a situation where you need to perform a partial matching within VLOOKUP. To assist you, today we are going to show you how to operate ...

How to Use IF Partial Match in Excel (4 Basic Operations)

Nov 25, 2021 Excel Formulas

IF is one of the most common functions in Excel. Depending on circumstances different logical operations can be performed through this function. We ...

How to Perform Partial Match String in Excel (5 Methods)

Nov 17, 2021 Excel Formulas

Whenever you are handling a wide range of data in your worksheet, partial matching or fuzzy matching is an effective way to find your match quickly. ...

Lookup Partial Text Match in Excel (5 Methods)

Nov 17, 2021 Excel Formulas

In Microsoft Excel, there are several useful methods to lookup partial text matches and then extract data based on that specific match. In this ...

COUNTIF Partial Match in Excel (2 or More Approaches)

Nov 25, 2021 Excel Formulas

COUNTIF is one of the most frequently used functions in Excel. A lot of tasks can be done using this function, one of them is the partial match. ...