Latest Blog Posts - Page 422 of 589

How to Extract Text Between Two Characters in Excel: 4 Methods

Apr 16, 2024

Here is a dataset containing Reference and Client Code. Let's extract the text between two slashes. Read More: How to Extract Text Before ...

How to Extract Text Between Two Characters in Excel: 4 Methods

How to Select Range from Active Cell Using VBA in Excel: 3 Effective Methods

May 29, 2024

Method 1 - Employing VBA to Select Range from Active Cell to the Last Non-Blank Cell Steps: From the Developer tab >>> select Visual ...

How to Select Range from Active Cell Using VBA in Excel: 3 Effective Methods

Excel VBA: Change Font Color for Part of Text: 3 Methods

May 29, 2024

Method 1 - Change the Font Color for a Specific Part of Text Using VBA in Excel 1.1 Use of the Font.Color Property Along with the above property, ...

Excel VBA: Change Font Color for Part of Text: 3 Methods

How to Extract Specific Data from a Cell in Excel (3 Examples)

Jul 4, 2024

Example - 1 Extracting Specific Text Data from a Cell in Excel through Functions Case 1.1 - Extracting Data from the Beginning of a Cell with ...

How to Extract Specific Data from a Cell in Excel (3 Examples)

How to Create a Table Array in Excel (3 Methods)

Jul 3, 2024

In this article, we will provide 3 useful examples of how to create and use a table array. Watch Video – Create a Table Array in Excel ...

How to Create a Table Array in Excel (3 Methods)

How to Copy a Row Using Excel VBA If the Cell Value Matches (2 Methods)

Jul 24, 2024

Dataset Overview We’ll use the sample dataset below to demonstrate two methods. Method 1 - Copy Row to Another Sheet If One Cell Value ...

How to Copy a Row Using Excel VBA If the Cell Value Matches (2 Methods)

Excel VBA to Rotate Text to 90 Degrees (4 Easy Examples)

Jul 26, 2024

We will show 4 VBA code examples to rotate text to 90 degrees. We will use the following dataset for the examples. Example 1 - Excel VBA ...

Excel VBA to Rotate Text to 90 Degrees (4 Easy Examples)

Loan Amortization Schedule with a Variable Interest Rate in Excel – Free Download

Aug 4, 2024

A Loan amortization schedule with a variable interest rate allows the borrower to trace his/her loan repayment by calculating the principal paid, ...

Loan Amortization Schedule with a Variable Interest Rate in Excel – Free Download

How to Use VLOOKUP Table Array Based on Cell Value in Excel

Jul 3, 2024

We are using a dataset where we stored some data on sports equipment. We have the Product IDs, Product Names, and their previous and current prices. ...

How to Use VLOOKUP Table Array Based on Cell Value in Excel

The Excel Wrap Text Option is Not Working for Merged Cells – 5 Solutions

Aug 3, 2024

The dataset showcases Quotes and the corresponding Authors. Each quote covers 3 cells and the text isn't completely displayed. Wrap the text after ...

The Excel Wrap Text Option is Not Working for Merged Cells – 5 Solutions

How to Extract Year from Date in Excel (3 Ways)

Jul 25, 2024

We have a dataset that includes player names and their dates of birth. We want to extract the year from the dates. Method 1 - Inserting ...

How to Extract Year from Date in Excel (3 Ways)

Excel Macro: Sort Multiple Columns with Dynamic Range (4 Methods)

Nov 11, 2025

While working with large Microsoft Excel, sometimes we need to sort multiple columns with a dynamic range. We can easily do that by using the VBA ...

Excel Macro: Sort Multiple Columns with Dynamic Range (4 Methods)

VBA to Loop through Rows and Columns in a Range in Excel (5 Examples)

Jul 16, 2024

We will use a dataset that contains information about the Sales Amount of the first two months of some sellers. Example 1 - Apply VBA ...

VBA to Loop through Rows and Columns in a Range in Excel (5 Examples)

How to Compare Two Tables for Differences with Excel VBA (3 Methods)

Nov 11, 2025

In this article, I’ll show you how you can compare two tables for differences using VBA in Excel. You’ll learn to compare two tables by finding out ...

How to Compare Two Tables for Differences with Excel VBA (3 Methods)

How to Remove Text between Two Characters in Excel (3 Easy Ways)

Aug 1, 2024

The dataset contains information about the names of some employees and their delivery times & dates of products. We do not want the delivery time ...