0
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

【Excel】Unicodeを表示する関数

Posted at

やること

【Excel】VBAで環境依存文字で項番を割り振る方法 #ExcelVBA - Qiitaを見て、㊿まで表示出来なかったっけ?と思い、Unicodeを表示する関数を作成する。

作成した関数

Function GetUnicodeChar(Cell As Range) As String
    Dim ch As String
    Dim code As Long
    ch = Cell.Value
    If Len(ch) > 0 Then
        code = AscW(ch)
        GetUnicodeChar = "U+" & Hex(code)
    Else
        GetUnicodeChar = ""
    End If
End Function

20250324 002500.jpg

関連記事

Unicodeの丸数字(①とか)でやられた件 #JavaScript - Qiita

36にまた見えない壁があったのか...
ここでようやくGoogle先生にご相談 
Wikipadiaにまさに丸数字のページが!!!

わざわざ関数作る必要なかった:weary:

0
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?