Data Cleaning in Excel Archives

How to Remove Comma in Excel: 5 Methods

Jul 4, 2024

Method 1 - Removing Comma from Numbers in Excel A comma can appear in the numbers as part of the cell formatting. Numbers are stored as text ...

How to Find, Count & Fill Missing Values in Excel

Jul 5, 2024

Method 1 - Finding Missing Values Using a Combination of IF and COUNTIF Functions Steps: Select cell F5. Enter the formula below: ...

How to Find, Count & Fill Missing Values in Excel

How to Remove Text in Excel? (3 Suitable Methods)

Jul 10, 2024

We'll use the following simple dataset to showcase how you can remove text. Download the Practice Workbook Text Remove.xlsx ...

How to Remove Text in Excel? (3 Suitable Methods)

How to Remove HTML Tags from Text in Excel: 2 Suitable Methods

Jul 6, 2024

Method 1 - Remove HTML Tags Using Find and Replace Tool Steps: Select the cells (B5:B9 here) where your texts with HTML tags are present. ...

How to Remove HTML Tags from Text in Excel: 2 Suitable Methods

How to Use Macro to Clean Up Data in Excel (4 Methods)

Jun 11, 2024

Below is a dataset in the range B2:B12 of a worksheet called Sheet1 that contains some school students' Student IDs, Student Names, Marks, ...

How to Use Macro to Clean Up Data in Excel (4 Methods)

Removing the Drop-Down Arrow in Excel: 6 Methods

Jun 16, 2024

Method 1 - Use the Filter Feature Steps: Select the range of cells for which you want to remove the arrow, e.g. columns B through E. ...

Removing the Drop-Down Arrow in Excel: 6 Methods

How to Remove Compatibility Mode in Excel (2 Easy Ways)

Jun 17, 2024

Opening an Excel file that was originally saved in an older version of Excel (i.e., Excel 1997 to 2003) will require Excel to open the workbook in ...

How to Remove Compatibility Mode in Excel (2 Easy Ways)

How to Remove Outliers in Excel (3 Ways)

Jun 17, 2024

Method 1 – Utilizing Trimmean to Calculate Average without Outliers Below, we have data from Cells B5 to B14. Most numbers are between 20 and 27, ...

How to Remove Outliers in Excel (3 Ways)

How to Remove 0 from Excel (7 Methods)

Apr 24, 2024

When we work with spreadsheets not prepared by us, we face different types of number formats in cells. For example, phone numbers may contain leading ...

How to Remove Partial Data from Multiple Cells in Excel (6 Methods)

Jun 27, 2024

Dataset Overview To make the explanation clear, I'll use a dataset representing product information from a fruit shop, but some information is ...

How to Remove Partial Data from Multiple Cells in Excel (6 Methods)

How to Remove a Value in Excel (9 Methods)

Jul 6, 2024

The below dataset has 5 columns: Product Name, Order ID, Price, Order Date, and Status. Method 1 - Using a Keyboard Shortcut Steps: ...

How to Remove a Value in Excel (9 Methods)

How to Remove Numbers from a Cell in Excel (7 Effective Ways)

Jul 6, 2024

We have placed some Product Names and their IDs in the dataset. We want to remove the numbers from the Product IDs. Method 1 - Using Find ...

How to Remove Numbers from a Cell in Excel (7 Effective Ways)

How to Remove Spaces in Excel Applying Formula, VBA & Power Query: 11 Methods

Jul 5, 2024

Method 1 - Use Excel TRIM Function to Remove All Leading and Trailing Spaces The TRIM function removes all spaces from a text string except for ...

How to Remove Spaces in Excel Applying Formula, VBA & Power Query: 11 Methods

How to Remove Characters in Excel (6 Methods)

Jul 6, 2024

Here's an overview of removing characters with various functions. Download the Practice Workbook Deleting Characters.xlsx 6 ...

How to Remove Characters in Excel (6 Methods)

19 Practical Data Cleaning Techniques in Excel

Jun 16, 2024

Method 1 - Remove Duplicate Rows Here's a sample dataset that contains duplicate rows. Let’s replicate the column and remove the ...