Thursday, November 21

Tag: use of char function

CHAR Function To Display Symbol In Excel

CHAR Function To Display Symbol In Excel

FORMULAS, Text
DEFINITION: CHAR means CHARACTER. The CHAR function in Excel returns a specific symbol or character based on a code number provided. Which is between 1 to 255. These characters are inbuilt Characters. These characters cannot be typed from keyboard. Please Check The Table Below/ NOTE: Some Character Number May Display The Similar Or Same Symbol As Other. Syntax: =CHAR (number) Formula ResultFormula ResultFormula ResultFormula Result=CHAR(1)=CHAR(65)A=CHAR(129)=CHAR(193)Á=CHAR(2)=CHAR(66)B=CHAR(130)‚=CHAR(194)Â=CHAR(3)=CHAR(67)C=CHAR(131)ƒ=CHAR(195)Ã=CHAR(4)=CHAR(68)D=CHAR(132)„=CHAR(196)Ä=CHAR(5)=CHAR(69)E=CHAR(133)…=CHAR(197)Å=CHAR(6)=CHAR(70)F=CHAR(134)†=CHAR(198)Æ=CHAR(7)=CHAR(71)G=CHAR(135)‡=CHAR(199)Ç=CHAR(8)=CHAR(72)H=CHAR(136)ˆ=CHAR(200)È=C...