Latest Blog Posts - Page 517 of 587

How to Find Duplicate Rows in Excel (5 Quick Ways)

Jun 14, 2024

Here's an overview of finding duplicated values across rows. How to Find Duplicate Rows in Excel: 5 Quick Ways We will use some ...

How to Separate Two Words in Excel (6 Easy Ways)

Apr 16, 2024

The following image shows one of the ways to separate two words in Excel. Read on to learn more. Let’s say we have a dataset containing a ...

How to Separate Two Words in Excel (6 Easy Ways)

Insert Rows in Excel Based on Cell Value with VBA (2 Methods)

May 28, 2024

Cells(2,3).EntireRow.Insert This line inserts a row above cell C2 (Row 2, Column 3). Insert Rows Based on Cell Value with VBA: 2 ...

Insert Rows in Excel Based on Cell Value with VBA (2 Methods)

How to Paste Transpose in Excel Using Shortcut: 4 Methods

Jul 7, 2024

Method 1 - Using Ribbon Paste Shortcut to Transpose in Excel We can transpose by using the Ribbon commands. The process is given below: Steps: ...

How to Paste Transpose in Excel Using Shortcut: 4 Methods

How to Convert Text to Date in Excel (10 Ways)

Jul 29, 2024

Here's an overview of a list of dates in textual values that will be converted to dates. How to Convert Text to Date in Excel: 10 Ways We ...

How to Split a Cell into Two Rows in Excel (3 Easy Ways)

Jun 24, 2024

Here's an overview of splitting a cell into two rows in Excel. We'll use dataset with two columns: Author and Book Name. There are some cells ...

How to Split a Cell into Two Rows in Excel (3 Easy Ways)

How to Create an Invoice using an Excel Formula – 8 Steps

Aug 13, 2024

This is the sample dataset. Download Practice Workbook Download this practice workbook. Invoice Excel Formula.xlsx Include: ...

How to Create an Invoice using an Excel Formula – 8 Steps

How to Convert Date to Text Month in Excel (7 Quick Ways)

Nov 11, 2025

When we enter a date in Excel then it is possible to extract the month name from the date. This article will guide you with 7 quick useful methods to ...

How to Convert Date to Text Month in Excel (7 Quick Ways)

How to Delete Row If Cell Contains Specific Values in Excel?

Jul 29, 2024

We will be using a sample dataset that contains the Name and Age of some people. Method 1 - Using Find and Replace to Delete a Row If a ...

How to Delete Row If Cell Contains Specific Values in Excel?

How to Convert Text to Number in Excel with VBA

Jun 16, 2024

How to Identify Numbers Formatted as Text Take a look at this dataset. We have some numbers in a column. Though we have numbers ...

How to Convert Text to Number in Excel with VBA

How to Convert Number (YYYYMMDD) to Date Format in Excel – 4 Methods

Aug 3, 2024

Several Date formats are available in Excel. This is the sample dataset. Method 1 - Using the TEXT Function to Convert Number ...

How to Convert Number (YYYYMMDD) to Date Format in Excel – 4 Methods

COUNTIF That Does Not Contain Multiple Criteria in Excel

Nov 11, 2025

We are used to applying the COUNTIF function in Excel to count the cells according to given criteria but it’s a little bit difficult to count the ...

COUNTIF That Does Not Contain Multiple Criteria in Excel

How to Delete Rows in a Range with VBA in Excel – 3 Methods

Aug 11, 2024

Observe the GIF: Click on the image for a better view. The VBA command will be used to delete an entire row. Customize the command to ...

How to Delete Rows in a Range with VBA in Excel – 3 Methods

Using a VBA Macro to Insert Rows in Excel Based on Criteria – 4 Methods

Aug 12, 2024

Method 1 - Using a VBA Macro to Insert Rows Based on the Cell Text Value in Excel To insert a new row based on the specific text value “Insert ...

Using a VBA Macro to Insert Rows in Excel Based on Criteria – 4 Methods

How to Convert Number to Date in Excel (6 Methods)

Jul 29, 2024

Overview In the following sections, I’ll explain various methods for converting numbers to dates using Excel. Whether you’re dealing with raw data ...