Identical strings doesn't match in excel / Power Query

[Daugaard92]

So I've a really annyoing issue, which has been bothing me for a couple of days.

I've various data-sets, which I compare in a "joint" pivot-table utilizing multiple data-connection. I have then created various "filtering-tables" consisting only of variables like "supplier-names" and then I use these as filters within my pivot table.

I've had great succes with this - However, one of my sources wont work. For some reason, although the strings look perfectly alike in Excel (See below), for some reason they don't match (FALSK/FALSE).

This means, that where I for my alternate data from Data source 1 and other data sources, is able to filter out a supplier name like: "EL-NET ØST (BORNHOLM)", I'm unable to do the same for Data source 2 for some reason. If i delete and retype the entire text for data source 2:, then the two strings match; However, I obviously can't do this for a large data-set.

I've tried editing source 2 within Power Query by changing the format, but I just can't find a solution that works. Does anyone know what I might do, which could fix this issue?

I link to the file is here, so you can see for yourself:

Strings aren't identicla.xlsx

Shared with Dropbox

www.dropbox.com

 

[RoryA]

Please don't post the same question more than once. Thread closed.