FIND Function Archives

Excel If Cell Begins with Certain Text Then Return Value

May 11, 2023

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

Excel If Cell Begins with Certain Text Then Return Value

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

Jan 18, 2023

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 Apply Engineering Number Format in Excel (2 Easy Ways)

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

Feb 7, 2023

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 Return TRUE If Cell Contains Text in Excel (8 Easy Ways)

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

Dec 27, 2022

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 Find RegEx Patterns in Excel (2 Suitable Methods)

How to Convert Complex Numbers to Polar Form in Excel

Feb 7, 2023

This article will illustrate how to deal with the Polar form of complex numbers in Excel. Download Practice Workbook You can download the ...

How to Convert Complex Numbers to Polar Form in Excel

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

Jan 2, 2023

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 Truncate Text After Character in Excel (4 Suitable Ways)

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

Feb 27, 2023

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 Perform Pattern Matching in Excel (2 Suitable Methods)

How to Truncate Numbers in Excel (8 Suitable Methods)

Feb 7, 2023

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 Truncate Numbers in Excel (8 Suitable Methods)

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

Dec 29, 2022

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 Use REGEX without VBA in Excel (with Easy Steps)

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

Jan 1, 2023

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 Sort Numbers with Letter Suffix in Excel (4 Useful Methods)

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

Apr 27, 2023

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 Use REGEX to Match Patterns in Excel (6 Examples)

How to Apply Abbreviation Using Formula in Excel

May 31, 2023

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

How to Apply Abbreviation Using Formula in Excel

Convert Latitude and Longitude to Decimal Degrees in Excel

Feb 28, 2023

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

Convert Latitude and Longitude to Decimal Degrees in Excel

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

Dec 28, 2022

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 Remove Last 4 Digits of Zip Code in Excel (10 Easy Ways)

How to Convert Column to Text with Delimiter in Excel

Jan 16, 2023

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