Data clean-up techniques in Excel

Cleaning-up data in Excel covers many areas. We have covered almost every angle. Here are the links:

  1. Data clean-up techniques in Excel: Removing duplicate rows
  2. How to Find, Highlight & Remove Duplicates in Excel.
  3. How to split a text into multiple cells in Excel
  4. Data clean-up techniques in Excel: Changing the case of text
  5. Data clean-up techniques in Excel: Transforming Data with Formulas
  6. Data clean-up techniques in Excel: Removing extra spaces
  7. Data clean-up techniques in Excel: Removing strange characters
  8. Data clean-up techniques in Excel: Converting values
  9. Data clean-up techniques in Excel: Classifying values
  10. Data clean-up techniques in Excel: Joining columns
  11. Data clean-up techniques in Excel: Rearranging columns
  12. Data clean-up techniques in Excel: Randomizing the rows
  13. Data clean-up techniques in Excel: Extracting a file name from a URL
  14. Data clean-up techniques in Excel: Matching text in a list
  15. Data clean-up techniques in Excel: Changing vertical data to horizontal data
  16. Data clean-up techniques in Excel: Filling blank cells
  17. Data clean-up techniques in Excel: Checking spelling
  18. Data clean-up techniques in Excel: Replacing or removing text in cells
  19. Data clean-up techniques in Excel: Adding text to cells
  20. Data clean-up techniques in Excel: Fixing trailing minus signs

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo