CHAR Function in MS EXCEL

No Comments

“CHAR”

Used for – “CHAR” Function in MS Excel is used find the character specified by the code number from the character set for your computer from 1 to 255 numbers.

Syntax – CHAR(Number).

Example – Following example will help to understand of CHAR formula,

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








2
=CHAR(48)








3
=CHAR(112)








4
=CHAR(211)








5









6









7










And result you get as under:-

A
B
C
D
E
F
G
H
I
1
!








2
0








3
P








4
Ó








5









6









7










Thus we see that this formula results only in the form of a character against a specified no in between 1 to 255.

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.