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 I can get each correspondent translation to Portuguese it'll only match a few items, as shown below:

After checking the other table's contents every correspondent Contract was there, but then after copying the entire Contract column from the API dataset and pasting it to a blank Excel spreadsheet I realized that the spaces displayed on Power Query are actually some unrecognizable characters displayed as "?" inside a diamond:

I've already tried the Clean tool but it won't work. I also tried other think such as Trim and Replace Values... space by something else and no glory.

Something tells me I need to figure out which character is actually being imported instead of space so I can try to replace it on Power Query, but the question is: how can I do that? How can I turn those "?" into readable characters in Excel?!

Leonardo

CodePudding user response：

try something like:

=UNICODE(MID(A4, SEQUENCE(,LEN(A4)),1))

and fill down. You should see codes for all the characters in the adjacent row. (Be sure the row is clear or you will the #SPILL! error)