en | de
Worldwide Content
Jul 8, 2022 12:00 AM

Data Cleaning PRO Tip: Dealing with text & numbers in same column

Recently I had to deal with a weird data clean up scenario. My client (a large hotel chain) was getting room booking data with mixed format. The booking date column occasionally has a text value which needs to extracted and used for proper analysis. In this short tip video, let me show you how to deal with such problems using Excel.

  • The text & numbers problem
  • Avoiding the problem by removing text data
  • How to separate and properly arrange data (with Power Query)

  • Know-HowContent Type
  • Jul 7, 2022First published
  • 1 minReading Time
  • EnglishArticle Language