How to Use VBA LCase Function in Excel (3 Easy Examples)

When working in VBA, we often need to convert certain strings into lowercase, uppercase, or proper case strings. In this article, we will talk about ...

How to Use VBA SPLIT Function in Excel (10 Ideal Examples)

How to Launch the VBA Editor in Excel If you don’t see the Developer tab, enable the Developer tab. Select the Developer tab and click on ...

How to Use the VBA Trim Function in Excel – 5 Examples

This is an overview. The VBA TRIM Function Summary The Trim function in VBA removes the leading and trailing spaces from a ...

How to Use ISLOGICAL Function in Excel (4 Examples)

In Microsoft Excel, the ISLOGICAL function is generally used to check whether a given argument contains a boolean value (TRUE or FALSE) or not. In ...

How to Use the ISTEXT Function in Excel (8 Examples)

Excel ISTEXT Function: Syntax and Argument In this section, we will explain the syntax and argument of the ISTEXT function. ISTEXT Function of ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo