Import Chinese CSV to Excel

Posted on January 21, 2015May 6, 2019 by Wyman W

This Excel tutorial explains how to import Chinese CSV to Excel with correct encoding. (解決CSV轉EXCEL亂碼) You may also want to read: Export Chinese Excel to CSV Excel VBA Import CSV into Excel using Workbooks.OpenText Method Excel VBA convert CSV to Excel Import Chinese CSV to Excel When you import Chinese CSV to Excel, some Chinese characters will become a question mark "?" or convert to unexpected Chinese characters, same will happen for symbols and other languages such as Japanese,...

Export Chinese Excel to CSV

Posted on January 21, 2015September 16, 2017 by Wyman W

This Excel tutorial explains how to export Chinese Excel to CSV, the method is also applicable to other languages. (解決Excel轉CSV亂碼). You may also want to read: Import Chinese CSV to Excel Export Chinese Excel to CSV When you export Chinese Excel to CSV (Comma-separated values), some Chinese characters will become a question mark "?", same will happen for symbols and other languages such as Japanese, why is that? To understand what is happening, we need to know what is encoding. Compute...

Excel Shortcut key and function

Posted on January 19, 2015January 30, 2017 by Wyman W

This Excel tutorial summarizes a list of Excel shortcut key as well as Windows short cut key which are applicable to Excel. Excel Shortcut key Below is a table that summarizes most Excel shortcut key. I referred to the Microsoft website for the Excel shortcut key, removed some unimportant Excel shortcut key, and then combined with some Windows short cut key that are also applicable in Excel and finally reordered and changed description of each shortcut key. Some keys do not work in older ve...

Excel iterative calculation and circular reference

Posted on January 15, 2015January 15, 2015 by Wyman W

Excel iterative calculation and circular reference To understand what is Excel iterative calculation, you should first understand what is circular reference. Circular reference happens when you type a formula in one Cell which refers to another Cell, but that Cell also refers back to the Cell. For example, Cell A1: = 1+A2 Cell A2: = 1+A1 The above formula refer to each other, this is called circular reference (refer to each other forming a circle). The formula will fail and the be...