CODEWITHSUNDEEP
vbaexcelunicodeutf-16
Amen Jlili
Amen Jlili

Reputation: 1934

Excel not displaying unicode characters

I've tried to print the Unicode characters (UTF-16) using the following code:

Sub PrintUnicode()
For Each Cell In Range("A1:J6553") '2^16/10: displays 10 chars in each line
Cell.Value = ChrW(i)
i = i + 1
Next
End Sub

Sample output:

enter image description here

So the actual character id if you will is: 10*(RowNumber-1) + ColumnNumber

After browsing the spreadsheet downwards, I started noticing empty rows. Playing around with these rows, I noticed some of cells looked empty and other cells had invisible values that were only visible when you double clicked on the cell.

I filtered them out:

enter image description here

Can someone please explain to me this unexpected behavior?

Upvotes: 0

Views: 1645

Answers (1)

BrakNicku
BrakNicku

Reputation: 5991

Please take a look here: Combining character You can test it using: 

Cell.Value = "a" & ChrW(i)

Upvotes: 1

Related Questions