CODE

Formula Explanation

CODE returns the numeric code for the first character in a text string. The returned code corresponds to the character set used by the local machine.

• Macintosh: Macintosh character set

• Windows: ANSI character set

Formula Syntax

Enter in the result column: CODE(column_number / text);

The CODE function syntax has the following argument:

• Text is required. It is the text for which you want to get the code of the first character.

Usage Examples

1. Display the numeric codes for the values in column BW2, and write the results into column BW3.

BW3 = CODE(BW2);

2. Display the numeric code for the character "!" in column BX2.

BX2 = CODE("!");

✉️ Ask Tablize