SEARCH Function

### How to Find Carriage Return in Excel (2 Easy Methods)

Carriage return is a very important element in excel cells. It defines the cell length along with the information within it. In some cases, we need ...

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

Users frequently need to add text in Excel spreadsheet. In this way, they are able to communicate text data. They might need to add a prefix or ...

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

### How to Organize Things Alphabetically in Excel (4 Methods)

Organizing data alphabetically is one of the most basic tasks in Excel. Indeed, it is also a valuable tool when working with large sets of data. ...

### 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 Format a Column for Email Addresses in Excel (2 Easy Ways)

In this article, we will learn to format a column for email addresses in Excel. In Microsoft Excel, we often insert email addresses for various ...

### 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 Count Specific Names in Excel (3 Useful Methods)

While investigating large datasets in Excel, you might be required to count the number of cells containing a specific name. This article provides 3 ...

### 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 ...  5 Excel Hacks You Never Knew  