Uploaded February 2025 | Updated November 2026, 1 day ago
Have you ever encountered an Excel dataset where spaces don’t behave like spaces? In this lesson, we explore an issue where seemingly identical text values don’t get recognized as duplicates—even after using Text.Clean or Power Query’s Remove Duplicates feature! We uncover the mystery behind non-breaking spaces and hidden characters that can cause unexpected issues in your data. With the help of MVP experts, we demonstrate step-by-step how to detect and remove these tricky characters using Power Query’s Replace Values and delimiter splitting techniques. By the end of this tutorial, you’ll have the tools to ensure your datasets are truly clean!
Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
Have you ever encountered an Excel dataset where spaces don’t behave like spaces? In this lesson, we explore an issue where seemingly identical text values don’t get recognized as duplicates—even after using Text.Clean or Power Query’s Remove Duplicates feature! We uncover the mystery behind non-breaking spaces and hidden characters that can cause unexpected issues in your data. With the help of MVP experts, we demonstrate step-by-step how to detect and remove these tricky characters using Power Query’s Replace Values and delimiter splitting techniques. By the end of this tutorial, you’ll have the tools to ensure your datasets are truly clean!
Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link










![How to get 6 million views on YouTube [satire]
🫶🏻 Join the channel to get access to perks:
https://www.youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🧑🏻🎓Learning Power BI?
Check out our online course
https://accessanalytic.thinkific.com/
📗 Did you know Ive written a book Power BI for the Excel Analyst?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/ How to get 6 million views on YouTube [satire]](https://i.ytimg.com/vi/7y3N5EzP9kw/mqdefault.jpg)