Friday, May 17

CHAR Function To Display Symbol In Excel

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)È
=CHAR(9)=CHAR(73)I=CHAR(137)=CHAR(201)É
=CHAR(10)
=CHAR(74)J=CHAR(138)Š=CHAR(202)Ê
=CHAR(11)
=CHAR(75)K=CHAR(139)=CHAR(203)Ë
=CHAR(12) =CHAR(76)L=CHAR(140)Œ=CHAR(204)Ì
=CHAR(13)
=CHAR(77)M=CHAR(141)=CHAR(205)Í
=CHAR(14)=CHAR(78)N=CHAR(142)Ž=CHAR(206)Î
=CHAR(15)=CHAR(79)O=CHAR(143)=CHAR(207)Ï
=CHAR(16)=CHAR(80)P=CHAR(144)=CHAR(208)Ð
=CHAR(17)=CHAR(81)Q=CHAR(145)=CHAR(209)Ñ
=CHAR(18)=CHAR(82)R=CHAR(146)=CHAR(210)Ò
=CHAR(19)=CHAR(83)S=CHAR(147)=CHAR(211)Ó
=CHAR(20)=CHAR(84)T=CHAR(148)=CHAR(212)Ô
=CHAR(21)=CHAR(85)U=CHAR(149)=CHAR(213)Õ
=CHAR(22)=CHAR(86)V=CHAR(150)=CHAR(214)Ö
=CHAR(23)=CHAR(87)W=CHAR(151)=CHAR(215)×
=CHAR(24)=CHAR(88)X=CHAR(152)˜=CHAR(216)Ø
=CHAR(25)=CHAR(89)Y=CHAR(153)=CHAR(217)Ù
=CHAR(26)=CHAR(90)Z=CHAR(154)š=CHAR(218)Ú
=CHAR(27)=CHAR(91)[=CHAR(155)=CHAR(219)Û
=CHAR(28)=CHAR(92)\=CHAR(156)œ=CHAR(220)Ü
=CHAR(29)=CHAR(93)]=CHAR(157)=CHAR(221)Ý
=CHAR(30)=CHAR(94)^=CHAR(158)ž=CHAR(222)Þ
=CHAR(31)=CHAR(95)_=CHAR(159)Ÿ=CHAR(223)ß
=CHAR(32) =CHAR(96)`=CHAR(160) =CHAR(224)à
=CHAR(33)!=CHAR(97)a=CHAR(161)¡=CHAR(225)á
=CHAR(34)=CHAR(98)b=CHAR(162)¢=CHAR(226)â
=CHAR(35)#=CHAR(99)c=CHAR(163)£=CHAR(227)ã
=CHAR(36)$=CHAR(100)d=CHAR(164)¤=CHAR(228)ä
=CHAR(37)%=CHAR(101)e=CHAR(165)¥=CHAR(229)å
=CHAR(38)&=CHAR(102)f=CHAR(166)¦=CHAR(230)æ
=CHAR(39)=CHAR(103)g=CHAR(167)§=CHAR(231)ç
=CHAR(40)(=CHAR(104)h=CHAR(168)¨=CHAR(232)è
=CHAR(41))=CHAR(105)i=CHAR(169)©=CHAR(233)é
=CHAR(42)*=CHAR(106)j=CHAR(170)ª=CHAR(234)ê
=CHAR(43)+=CHAR(107)k=CHAR(171)«=CHAR(235)ë
=CHAR(44),=CHAR(108)l=CHAR(172)¬=CHAR(236)ì
=CHAR(45)=CHAR(109)m=CHAR(173)­=CHAR(237)í
=CHAR(46).=CHAR(110)n=CHAR(174)®=CHAR(238)î
=CHAR(47)/=CHAR(111)o=CHAR(175)¯=CHAR(239)ï
=CHAR(48)0=CHAR(112)p=CHAR(176)°=CHAR(240)ð
=CHAR(49)1=CHAR(113)q=CHAR(177)±=CHAR(241)ñ
=CHAR(50)2=CHAR(114)r=CHAR(178)²=CHAR(242)ò
=CHAR(51)3=CHAR(115)s=CHAR(179)³=CHAR(243)ó
=CHAR(52)4=CHAR(116)t=CHAR(180)´=CHAR(244)ô
=CHAR(53)5=CHAR(117)u=CHAR(181)µ=CHAR(245)õ
=CHAR(54)6=CHAR(118)v=CHAR(182)=CHAR(246)ö
=CHAR(55)7=CHAR(119)w=CHAR(183)·=CHAR(247)÷
=CHAR(56)8=CHAR(120)x=CHAR(184)¸=CHAR(248)ø
=CHAR(57)9=CHAR(121)y=CHAR(185)¹=CHAR(249)ù
=CHAR(58):=CHAR(122)z=CHAR(186)º=CHAR(250)ú
=CHAR(59);=CHAR(123){=CHAR(187)»=CHAR(251)û
=CHAR(60)<=CHAR(124)|=CHAR(188)¼=CHAR(252)ü
=CHAR(61)==CHAR(125)}=CHAR(189)½=CHAR(253)ý
=CHAR(62)>=CHAR(126)~=CHAR(190)¾=CHAR(254)þ
=CHAR(63)?=CHAR(127)=CHAR(191)¿=CHAR(255)ÿ
=CHAR(64)@=CHAR(128)=CHAR(192)À  

Leave a Reply

Your email address will not be published. Required fields are marked *