Excel Guides

Getting Rid of 8-Bit ASCII Characters in Excel

If you have ever opened up an Excel spreadsheet only to be greeted by a mess of 8-bit ASCII characters, then you know how frustrating it can be. But don't despair! There are a few ways to get rid of those pesky characters and get your data back to normal.

The first thing you'll want to do is try to open up the file in a text editor like Notepad++ or Sublime Text. If the file opens up without any problems, then you can simply save it as a new file and the 8-bit ASCII characters will be gone. If the file won't open in a text editor, or if it opens but all the data is jumbled up, then you'll need to use a different method.

One way to fix 8-bit ASCII characters is to use an online tool like this one from Code Page Analyzer. Simply upload your file to the website and it will analyze the file and tell you what code page it's using. You can then download a new version of the file that uses a different code page.

If you're feeling really ambitious, you can also try fixing the problem yourself using a hex editor. This is definitely not for beginners, but if you're familiar with hexadecimal values and character encoding, then it might be worth a shot. Simply open up the file in a hex editor and look for any invalid characters. Once you find them, you can replace them with the correct character using the appropriate code page.

No matter which method you choose, getting rid of 8-bit ASCII characters in Excel is relatively easy once you know what to do. So don't be discouraged if your data looks like a mess at first - with a little effort, you can get it back to normal in no time!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.