1
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

Excelなどでチェックマーク(✓、✗、⛝)を入力する

Last updated at Posted at 2023-04-27

Excel関数で入力する

UNICHAR関数を使用すると引数の数値(10進数)により参照されるUnicode文字を返します。

例)「✓」を入力したい場合
=UNICHAR(HEX2DEC("2713"))
uni.png

入力する数式 表示される文字 入力する数式 表示される文字
=UNICHAR(HEX2DEC("2713")) =UNICHAR(HEX2DEC("2705"))
=UNICHAR(HEX2DEC("2714")) =UNICHAR(HEX2DEC("274E"))
=UNICHAR(HEX2DEC("2715")) =UNICHAR(HEX2DEC("26DD"))
=UNICHAR(HEX2DEC("2716")) =UNICHAR(HEX2DEC("2610"))
=UNICHAR(HEX2DEC("2717")) =UNICHAR(HEX2DEC("2611"))
=UNICHAR(HEX2DEC("2718")) =UNICHAR(HEX2DEC("2612"))
=UNICHAR(HEX2DEC("274C")) =UNICHAR(HEX2DEC("25A3"))

コピペする

そもそも2000-2FFFのページから直接コピペするだけでOKです。ExcelだけでなくWordやメモ帳でもそのままコピペ可能です。

1
0
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
1
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?