How to Use the ISNA Function in Excel – 3 Examples

This is an overview. The ISNA Function in Excel The ISNA function is an INFORMATION function in Excel. It checks whether a cell contains ...

How to Use ISEVEN Function in Excel (2 Suitable Examples)

Today I will be showing how you can decide whether a number is even or odd using the ISEVEN function of Excel. This function helps us to define even ...

How to Use ISODD Function in Excel (4 Suitable Examples)

The ISODD is one of the Excel information functions. It is a reference function that assists to show if a given number is odd or not. This article ...

How to Use the ISNUMBER Function in Excel (7 Methods)

The ISNUMBER function in Microsoft Excel is commonly used to determine whether a given argument contains a numerical value. The above ...

How to Use the TRIM Function in Excel (7 Examples)

Introduction to the Excel TRIM Function The Excel TRIM function is categorized under the TEXT functions. It removes the extra spaces from a text ...

How to Use ISBLANK Function in Excel (3 Examples)

In this article, we will discuss Excel's ISBLANK function, as in the following gif. Excel ISBLANK Function: Syntax and Argument ISBLANK ...

How to Use the SUBSTITUTE Function in Excel (7 Examples)

In this article, we will demonstrate some uses of the SUBSTITUTE function with examples. Excel SUBSTITUTE Function: Quick View ...

How to Use ISERROR Function in Excel (with 5 Examples)

If you are looking for how to use the ISERROR function in Excel then you are in the right place. For ignoring any type of calculation error, it is ...

How to Use UPPER Function in Excel (4 Examples)

In Microsoft Excel, the UPPER function is generally used to convert all the letters in a string of text to block ones. In this article, you’ll get to ...

How to Use the SEARCH Function in Excel – 3 Examples

This is an overview of the SEARCH function. Introduction to the SEARCH Function Summary The SEARCH function returns the number of ...

How to Use Excel PROPER Function (2 Ideal Examples)

Fortunately, there are several text functions in Excel to help you perform your desired tasks easily and swiftly. Today, we are going to show you how ...

How to Use TEXT Function in Excel (10 Examples)

Here's an overview of a few applications of the TEXT function in Excel. Introduction to the TEXT Function Function Objective: ...

How to Use RIGHT Function in Excel: 6 Suitable Examples

Method 1 - Using RIGHT Function to Get a Substring Until Space Step 1: Write down the below formula in cell C5. ...

How to Use MID Function in Excel (5 Ideal Examples)

The MID function extracts a specified number of characters from a cell with a customizable starting point. In this article, we will demonstrate 5 ...

How to Use LEFT Function in Excel: 4 Suitable Methods

Method 1 - Basic Use of LEFT Function: Extract String from Left Side Steps: Select Cell D5 and insert the following formula. =LEFT(B5,4) ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo