I'm using Power Query to combine several .csv files into a single Excel table. Everything works fine if I'm importing the files one by one but when I'm using the From Folder selection Power Query replaces umlauts and other non English alphabets with weird special characters. Is there a way to keep that from happening? Even the Replace Values doesn't seem to fix the problem in Power Query.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Power Query data problem
- Thread starter Misca
- Start date
Excel Facts
Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
ralliartur
New Member
- Joined
- Apr 15, 2015
- Messages
- 30
Hi,
It seems that you have problems with encoding declaration for this files - you should have parameter like that at the end -> "Encoding=1250" (the number should be the same as for individual files)
It seems that you have problems with encoding declaration for this files - you should have parameter like that at the end -> "Encoding=1250" (the number should be the same as for individual files)
Upvote
0
Similar threads
- Replies
- 5
- Views
- 323
- Replies
- 1
- Views
- 122
- Replies
- 0
- Views
- 146
- Question
- Replies
- 1
- Views
- 240
- Replies
- 3
- Views
- 271
