MS Excel is not able to detect the UTF-8 encoding and act accordingly. This leads to display garbled foreign language characters. So as a workaround i go to Data->Import->From text and choose the corresponding file and select the UTF-8 encoding format and delimiter as (,) and proceed will show foreign characters properly. But in such a case it won't show the new line character ("\n") properly, if a cell value contains a new line character it get break and displayed in the next line. Someone please suggest a solution for this problem.
Asked
Active
Viewed 612 times
-2
-
Use a decent spreadsheet application. ;-P Seriously though, will you have to support Excel *among other application*, or are you targeting Excel exclusively? – deceze Oct 21 '13 at 15:46
-
In open office it's working fine. I need a solution for this in Excel – Mady Oct 21 '13 at 16:23
1 Answers
0
To put a new line in Windows you should use \r\n to \retur\n.
randiel
- 280
- 1
- 16
-
1
-
Yes! i take from [this thread.](http://stackoverflow.com/questions/6539801/reminder-r-n-or-n-r) – randiel Oct 21 '13 at 15:50
-
when you write your text file you insert chr(10)+chr(13) ? or your files come from external origin and you should use "as is". Can you send a example two rows of data ? – randiel Oct 21 '13 at 16:39
-
1