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 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

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 here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply