Advanced Excel Archives - Page 58 of 65

How to Delete Everything After a Character in Excel -7 Methods

Aug 11, 2024

Method 1 - Applying the Find and Replace Option to Delete Everything After a Character in Excel Steps: Select the dataset (B5:B9). ...

How to Delete Everything After a Character in Excel -7 Methods

How to Remove Non-Alphanumeric Characters in Excel?

Nov 11, 2025

Today, in this article, we will demonstrate how to remove non-alphanumeric characters from cells in Excel. It is a very common problem, especially ...

How to Remove Non-Alphanumeric Characters in Excel?

VBA Range with Variable Row Number in Excel – 4 Examples

Aug 2, 2024

This is an overview: Sub Range_with_Variable_Row_Number() First_Cell = InputBox("Enter the First Cell of the Range: ") Row_Number = ...

VBA Range with Variable Row Number in Excel – 4 Examples

How to Convert Column Number to Letter in Excel (3 Methods)

Jul 12, 2024

Method 1 - Convert Column Number to Letter in Excel Consider the following dataset which we will be using as our example to convert column number to ...

How to Convert Column Number to Letter in Excel (3 Methods)

How to Select Columns with VBA (3 Easy Ways)

May 16, 2024

Download the Practice Workbook Selecting Columns with VBA.xlsm 3 Ways to Select Columns with VBA Consider the List of Company ...

How to Select Columns with VBA (3 Easy Ways)

How to Select Cell with VBA in Excel (6 Useful Ways)

Jul 5, 2024

Download the Practice Workbook Select Cell with VBA.xlsm How to Select a Cell with VBA in Excel Method 1 - Select a Cell of the ...

How to Select Cell with VBA in Excel (6 Useful Ways)

VBA Macro to Delete Columns Based on Criteria in Excel: 8 Examples

Jun 27, 2024

Method 1 - VBA Macro to Delete Columns Based on Cell Value in Excel Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> ...

VBA Macro to Delete Columns Based on Criteria in Excel: 8 Examples

VBA to Convert Column Number to Letter in Excel (3 Methods)

Aug 4, 2024

In this article, we will demonstrate how to convert a column number to its corresponding column letter in Excel with VBA code using 3 methods: ...

VBA to Convert Column Number to Letter in Excel (3 Methods)

How to Remove Numeric Characters from Cells in Excel?

Jul 31, 2024

Method 1 - Apply TEXTJOIN Function to Remove Numeric Characters from Cells Steps: Create a new column, next to your existing column, where you ...

How to Remove Numeric Characters from Cells in Excel?

How to Split Cells in Excel (6 Easy Tricks)

Jul 3, 2024

Method 1 - Split Cells in Excel with the Text to Column Feature In the following table, we have some random names lying in the Text column. We'll ...

How to Split Cells in Excel (6 Easy Tricks)

Apply Conditional Formatting to Overdue Dates in Excel (3 Ways)

Jun 14, 2024

In this article, we will be using a project deadline list as a dataset to demonstrate all the methods. Method 1 - Apply Conditional ...

Apply Conditional Formatting to Overdue Dates in Excel (3 Ways)

How to Count Duplicates with Pivot Table in Excel

Nov 11, 2025

Sometimes we need to count the duplicates in an Excel PivotTable for easy calculation. The Excel PivotTable is an amazing feature. In this article, ...