How can Excel open a .txt file and keep 0x0D chars and foreign chars ß ä?

Question

How can Excel open a .txt file and keep 0x0D chars and foreign chars ß ä? The file is tab delimited.

Windows 7, Excel 2010

Edited ten minutes later.

I drag and drop one .txt file and it works fine. I drag and drop a second .txt file and it does not.

The second .txt file appears to be a different encoding. They both display fine with NotePad.

That's simply UTF-8 isn't it? – Raystafarian Mar 02 '15 at 14:13 — Raystafarian, Mar 02 '15 at 14:13

score 0 · Answer 1 · answered Mar 02 '15 at 13:53

0

Two ways

1) Open Microsoft Excel then drag&drop .txt file it will ask for field seperator etc.

2) Import from datasource follow the link below

answered Mar 02 '15 at 13:53

sreekanth

1 Answers1