View Single Post
 
Old 08-28-2024, 05:36 AM
NoSparks NoSparks is offline Windows 10 Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

That is ChrW(9608)

Code:
Sub CheckOfCharacters()
    Dim i As Integer, str As String
str = ActiveCell.Value
Debug.Print ActiveCell.Font.Name
For i = 1 To Len(str)
    Debug.Print Mid(str, i, 1) & "  =  " & Asc(Mid(str, i, 1)) & vbLf & _
                Mid(str, i, 1) & "  =  " & AscW(Mid(str, i, 1))
Next
End Sub
Reply With Quote