Forum Discussion
Solved
Power Query | How to determine/remove this non-printable character
Hi,
How do I remove this character as I already tried Transform > Clean but it didn't help:
In Power Query, it shows like this:
If loaded into Excel, it looks like this:
...
Hello Ovette,
Instead of the Clean method, go to Any Column group in the same Transform tab, then select Replace Values, and then replace this character � with nothing.
Hope that helps
Hello Ovette,
Instead of the Clean method, go to Any Column group in the same Transform tab, then select Replace Values, and then replace this character � with nothing.
Hope that helps