Forum Discussion
Solved
Figure out character showing as space on Power Query
After running an API GET request method I get a set of data whose snippet is shown by the below screenshot: However when I run a `Merge Queries` of the `Contract` column with another table so ...
Most probably it's always the same combination instead of space. It depends where you'd like to clean the text, in Excel or in Power Query. In any case that's like substitute of this combination on space.
In Excel you may check by UNICODE what are these characters after splitting the text.
Most probably it's always the same combination instead of space. It depends where you'd like to clean the text, in Excel or in Power Query. In any case that's like substitute of this combination on space.
In Excel you may check by UNICODE what are these characters after splitting the text.