00:00 Non breaking space in Power Query 2010
00:27 Import the table with the non breaking spaces as thousand separators
00:36 Decimal number type gives error messages
00:50 Locale not working with the non breaking spaces
01:20 Replace space not working in PowerQuery
01:54 Replace the non breaking spaces in PowerQuery Excel 2010
02:10 #(00a0) and remove (#)
02:50 Now use Locale
03:25 Do the opposite (replace full stop with comma)

Replacing a non breaking space in PowerQuery. This method is relevant for previous versions of PowerQuery. The newer version now has a specific search of this and other 'hidden' characters.

свернуть