CODE Function in MS Excel

“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.

• Tweet
• Share
• Share
• Share
• Share