CODE Function in MS Excel

No Comments

“CODE”

Used for – “CODE” function in MS Excel is used know the numeric value for the character as per the character set used by your computer. In other ways you can say it can do reverse of Function CHAR

Syntax – CODE(Text).

Example – Following example which is extended from example of CHAR function will help to understand of CODE Function,

A
B
C
D
E
F
G
H
I
1
=CHAR(33)
=CODE(A1)







2
=CHAR(48)
=CODE(A2)







3
=CHAR(112)
=CODE(A3)







4
=CHAR(211)
=CODE(A4)







5









6









7










And result you get as under:-

A
B
C
D
E
F
G
H
I
1
!
33







2
0
48







3
P
112







4
Ó
211







5









6









7










Thus, we see that this formula results only in the form of a number against a specified character as per the character set of computer.

Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.