FIND Function

### Excel If Cell Begins with Certain Text Then Return Value

While working on a large dataset sometimes you need to check certain values that begin with specific data. In case you work on a smaller dataset ...

### How to Apply Engineering Number Format in Excel (2 Easy Ways)

Scientific or engineering work must show the number format differs from other forms. As it makes scientists work more efficiently, it also helps them ...

### How to Return TRUE If Cell Contains Text in Excel (8 Easy Ways)

Sometimes we need to determine whether a cell contains text or not. Because that cell might be needed for other purposes where the cell format needs ...

### How to Find RegEx Patterns in Excel (2 Suitable Methods)

When it comes to finding one substring in another, Microsoft Excel offers users a number of options, including the Find and Replace tool and a few ...

### How to Truncate Text After Character in Excel (4 Suitable Ways)

In this article, we will learn how to truncate text after a character in Excel. Sometimes we need to truncate any cell information dependent on ...

### How to Perform Pattern Matching in Excel (2 Suitable Methods)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In Excel, we ...

### How to Truncate Numbers in Excel (8 Suitable Methods)

Truncating a number means decreasing the number of digits from the decimal section or from the right side of that number in mathematics. In Excel, ...

### How to Use REGEX without VBA in Excel (with Easy Steps)

If you are using REGEX without VBA in Excel, this article may help you in this regard. REGEX is the abbreviated form of the term "regular ...

### How to Sort Numbers with Letter Suffix in Excel (4 Useful Methods)

In our regular life, we often notice numbers with suffix letters such as product code, zip code, account code, insurance numbers and lots more. But ...

### How to Use REGEX to Match Patterns in Excel (6 Examples)

If you are trying to find a match with any REGEX pattern to your dataset in Excel, then this article may help you. A REGEX pattern is basically a ...

### How to Apply Abbreviation Using Formula in Excel

While working in Excel, users often need to abbreviate text. The texts can be the name of a person, company, or organization. But there is no single ...

### Convert Latitude and Longitude to Decimal Degrees in Excel

Latitude and Longitude have often been defined in the DMS (Degree, Minute, and Second) system. For practical purposes, this DMS system needs to be ...

### How to Remove Last 4 Digits of Zip Code in Excel (10 Easy Ways)

Zip codes are essential for delivering parcels through postal services to reach a correct destination. Zip codes contain 9 digits, among which the ...

### How to Convert Column to Text with Delimiter in Excel

We often need a list in a column in an Excel sheet to arrange in a horizontal orientation. We will need a delimiter to separate the texts in that ...

Advanced Excel Exercises with Solutions PDF