To open a txt file with excel. First open an empty excel, then click File=>Open=> Go the the file you want to open => click open.
Some ones say if we open it with option Windows(ANSI) we will get rid of garbage characters. But I tried my file with Windows(ANSI), did not get rid of garbage characters.
So I tried some other options, I tried Unicode (UTF-8) and got rid of garbage characters.
No comments:
Post a Comment