I am having a small problem with Unicode character 1771 (6EB). When I run:

Sub uniMagic()
s = ChrW(1771)
With Range("A1")
.Font.Name = "Arial Unicode MS"
.Value = s & "alpha" & s & "omega"
.Offset(0, 1).Value = Left(.Value, 5)
End With
End Sub

I noticed:

1. the positions of "alpha" and "omega" are reversed in the cell A1
2. the positions of "alpha" and "omega" are reversed in the formula bar
3. the formula br has the text way to the right rather than the left
4. the value in B1 seems to indicate that the left-most part of A1 really
IS "alpha"

What is happening??
--
Gary''s Student - gsnu200847