SEARCH Function Archives - Page 2 of 9

SEARCH Function

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

Jun 19, 2022 Excel Formulas

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)

Oct 4, 2022 Excel Formulas

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

Jun 1, 2022 Excel Formulas

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)

Sep 22, 2022 Excel Formulas

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)

Jun 1, 2022 Advanced Excel

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)

Jul 5, 2022 Excel Formulas

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

How to Extract Numbers after a Specific Text in Excel (2 Suitable Ways)

Jun 22, 2022 Excel Formulas

In this tutorial, we will demonstrate how to extract numbers after a specific text in Excel. In many instances, we need to extract a specific part of ...

How to Split Text in Excel Using Formula (5 Easy Ways)

Jul 5, 2022 Excel Formulas

Excel has many features to split text. But if you want to do it only using formulas then are several ways to do it. And using the formula is one of ...

How to Split Text after a Certain Word in Excel (7 Ways)

Jul 5, 2022 Excel Formulas

Sometimes, we have to split a sentence or a group of words. It helps us to understand the data better whenever there is a large text in a single ...

How to Split Text by Space with Formula in Excel (5 Ways)

Jul 5, 2022 Excel Formulas

There are numerous ways to split text in Excel. In this article, we will see several methods for Excel split text by space formula. We have a sample ...

How to Split Names in Excel (5 Effective Methods)

Sep 22, 2022 Excel Formulas

If you want to split names in Excel, this article is for you. Here, we will demonstrate to you 5 effective methods so that you can do the task ...

How to Separate Text in Excel (10 Easy Methods)

Jul 5, 2022 Excel Formulas

Often our texts are in a hard-to-read format. In this article, we’re going to show how to separate text in Excel in 10 easy methods. To demonstrate ...

Split Column in Excel by Word (5 Effective Ways)

Oct 4, 2022 Excel Formulas

This article illustrates 5 different ways you can split a column in excel by word. Suppose each cell of a column in a dataset contains a particular ...

How to Split Names Using Formula in Excel (4 Easy Methods)

Sep 22, 2022 Excel Formulas

In Microsoft Excel, there must have some cases when you need to split the full name. Excel has several methods to do this. It actually reduces your ...

How to Split Names with Comma in Excel (3 Suitable Ways)

Sep 22, 2022 Excel Formulas 2

In Excel, you may run into situations where you have to split names inside of cells separated with the comma a lot. In the event, you may need to ...