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
How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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
- 1
- Views
- 105
- Replies
- 5
- Views
- 358
- Replies
- 1
- Views
- 129
- Replies
- 0
- Views
- 155
- Question
- Replies
- 1
- Views
- 245
