Have you copied data from the internet and pasted it in Excel?
It can be very frustrating when the data is messy!
Sometimes there are data quality issues and you should examine the data before adding formulas and formatting.
In my case, I was copying some calendar related data for a template I’m working on and the date values needed correcting.
Download my Excel file
Download here or via my OneDrive (file 00114)
Watch my YouTube video
See how I caught the issue and several ways to fix it.
Subscribe to my YouTube channel and learn more!
Me With Fenton & Cali
My name is Kevin Lehrbass. I live in Markham, Ontario, Canada.
I’ve enrolled in Power Query Academy! Why not learn Power Query (Get & Transform) with me?
Check out my YouTube videos and my blog posts.