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:
ovetteabejuela,
Right click on your column and select "Replace Values" to replace this character with space, then trim your column.
Regards,
Lydia
ovetteabejuela,
Right click on your column and select "Replace Values" to replace this character with space, then trim your column.
Regards,
Lydia
Yes, actually that worked, I just never thought PQ is capable of recognizing non-print characters in the Replace... method.
