Returns a numeric code for the first character in a text string.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
CODE(text)The CODE function returns the character code corresponding to the first character of a text string. The returned code is based on the character set used by your computer, typically ASCII or Unicode.
=CODE("A")結果: 65
Returns the ASCII code for the uppercase letter A.
=CODE("Excel")結果: 69
Returns the code for the first character 'E'.
It returns a #VALUE! error.