Data cleansing In Excel

I have the given sales data  I’ll show you how we can clean this ten-thousand row data.

I have input sale data below

I want to clean this data  it has duplicates and spelling mistakes I will do it.

Steps Of Solution:

Step 1.

Select Data Except Headings

Step 1 Solution.

Select B1 By Clicking B1 Value And Then Press CTRL+SHFT+RIGHT ARROW+DOWN ARROW

Go to Conditional Formatting .

Go to Conditional Formatting then to Highlight Cell Rules click on Duplicates choose a color there and click OK.

Then go to Data.

Go to Data then to Data Tools and click on Duplicate Values.

and click on OK.

then your duplicate values will be removed.

then after that

Select the data

Then open another sheet and apply the TRIM formula there. After that go to the first sheet select the data, and press Enter.

So your data cleansing is done.

Thank you.

Leave a Reply

Your email address will not be published. Required fields are marked *