Power Query | How to determine/remove this non-printable character

[ovetteabejuela]

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:

[JonahSea]

Hi,

I have a similar problem, but the non-printable character is just behaving as a space ' ' when using find and replace. Trying to replace it just replaces spaces, leaving it unchanged. Is there any other way to find and replace these non-printable characters?

[Anonymous · Accepted solution]

@ovetteabejuela,

Right click on your column and select "Replace Values" to replace this character with space, then trim your column.



Regards,
Lydia

[ovetteabejuela]

Yes, actually that worked, I just never thought PQ is capable of recognizing non-print characters in the Replace... method.