[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

CODE

Syntax:

CODE ( string )

Description: Determines the numeric code of the first character in string.

Arguments:

Name

Type

Description

string

text

Designates a string containing one or more characters.

 

Return Type and Value: number – The numeric code of the first character in string.

However, if string is empty, #VALUE! is returned.

[Example:

CODE("abc") results in 97
CODE(A10) results in 97, when A1 contains abc

end example]