Latest Blog Posts

The Excel VBA MsgBox Function – MsgBox Types, Constants and Return Values

Download Practice Workbook Download the following workbook. Excel VBA MsgBox Function.xlsm The MsgBox Function in Excel ...

How to Use InStr Function in VBA (3 Easy Examples)

While working with Excel VBA codes, we come across a few built-in functions that convert a complex task into a small one-line code. InStr is such a ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo