Not working? Make sure you set Base to Decimal (Step 7). For my purposes, though, UTF-8 does a good enough job of displaying non-corrupted characters. Like Vasille says in the comment to this question, if your file is not actually in UTF-8 format, you may technically want to convert the characters within the file to the encoding you want before opening in Excel. For some other encoding, use the code page identifier, which you can find in the Text Import Wizard in Excel or in this list. In the Data Validation dialog box, select the Text Length item from the Allow: drop down box. Click the Data validation in the Data Tools group under Data tab.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |