Geek Answers Handbook

Unicode character mapping: Excel 2010 vs Excel 2013

I need to replace simple ASCII for Unicode characters in an Excel spreadsheet. For example, turn Ståle into Stale.

In Excel 2013, it works fine. But in Excel 2010, the "?" instead of a problematic character. Any ideas? Note that non-Ascii characters are correctly defined in Excel 2010, but characters are not displayed.

char = Mid(val, i, 1) char_code = AscW(char) If char_code > 127 Then MsgBox ("Problem with " & c.Address & " [" & char_code & "] " & StrConv(ChrW(char_code), vbUnicode)) End If

I also tried just

 MsgBox ("Problem with " & char & " " & ChrW(char_code))

Again he worked with Excel 2013, but not Excel 2010.

+4
source share
1 answer

Other studies show:

The MsgBox control for Excel 2010 does not support Unicode characters. Excel 2013 MsgBox does.

A Unicode character other than ASCII works fine when a character is inserted into a worksheet cell. The problem is only when using MsgBox to display it. The good news is that the problem is fixed in Excel 2013. More on this.

+2
source

More articles:


All Articles