6 Tricks to Quickly Clean Data in Excel

After viewing this tutorial, you will be able to perform useful time-saving data cleaning procedures in Excel.

6 helpful tips for cleaning data that you import into Excel. These tips will allow you to save a lot of time when making your imported data ready to use.

These tips include how to update formulas; how to change text in a list; how to break-up or split text in a list; and more.

[sudeshsrivastava]

Excel sheet start malfunctioning when we enter data in more than 50 lakh rows aprox. Means per excel sheet don't have capacity to contain more than 50 lakhs rows aprox. data. Now the question is how to remove duplicates in excel if data is in different excel workbooks and the total rows in all excel workbooks are more than 20 crore. Can any body provide solution?

[gauravamazingfacts]

Thank u for imparting knowledge that i don't had about excel.

[duanedonaldson]

Quickly update formulas, you mentioned moving the formula and related data to its own sheet prior to FIND REPLACE. If you only select a single cell where the formula is located, C2, and do a FIND, you are correct, the entire worksheet will be updated when you only want a single formula updated in C2. I believe that if you select more than a single cell, as an example, A2:C2, only the selected cells will be manipulated by the FIND REPLACE and only C2 has a formula so no danger of updating the entire worksheet multitude of formulas. Thanks so much for all your great videos.

[tamelajones]

You just help me so simply! I'm learning Excel for work and someone asked me how to do this and I was lost. Messed up my productivity tracker really badly. Now I can at least empty cells without removing the formatting. Thank you for saving my sanity!

[deepikaau]

Great learning. Please continue what you're doing. I have started loving to work on excel after watching your videos. Thanks.

[granand]

Sir will CTRL+Shift+Key select till end of data including blanks which might bf in-between

[exwhyz]

all action, no fluff = great video. Thanks

[smb]

I enjoyed watching it and learning!! Thanks!!

[ramadiga]

Hi u r doing a great job 👍 keep it up buddy