I thought I would post some knowledge about this subject, since I just found out tonight. I do a lot of work that is not considered "standard" by the programming community, so this may not prove useful to everyone. But if you ever use Excel to modify code that developers usually modify in IDEs, you may run into this issue (I use Excel all the time to patternize code and make use of the grid-based layout). Apparently, if you copy text from a code editor into Excel and copy it back into the editor, every space and linebreak between text is filled with ASCII characters or symbols that only certain parsers recognize and show. This problem occurred with all of these editors: Visual Studio Code, Visual Studio 2019, Eclipse. Funny enough, going through the same process using MS Word does not result in this anomaly. If this post is not removed by a moderator, it may prove to be useful to some here if they ever start coding in other languages.
Adam
Bookmarks