CHAR Function in Excel

Home/Excel Formulas/CHAR Function in Excel

What is the use of CHAR function?

CHAR Function in Excel returns the last or right most character(or Characters) in a text string.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

 CHAR Function in Excel Syntax

What is the syntax of CHAR function:


Where number – Is a number between 1 and 255 specifying which character you want. The character is from the character set used by your computer.

CHAR Function in Excel – Examples

  CHAR Function in Excel Examples

 In the above examples, you can observe how CHAR function is finding the character

 Example 1: Displays the 61 character in the set

Example 2: Displays the 65 character in the set

Example 3: Displays the 97 character in the set

Example 4: Displays the 57 character in the set

Example 5:  Displays the 33 character in the set and appending to the string “Hi”VBA example on CHAR function

Please find the list of ASCII values.


CHAR function is also available in VBA, following is the example code:

Dim sOutout As String
sOutout1 =CHR(80)

Output: P

By |January 18th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

Related pages

meeting agenda template powerpointexcel vba labelhide column excelit interview questions and answers for freshers pdfunhide a columnrun macro on open excelsorting tabs in excelms access mcq questions and answersexcel charting toolsquery sql database from excelautofilter macropivot table in excel 2007 with example pptvb syntaxproject dashboard templateproject management checklist exceldata definition language ddl commandexcel add chart titlehow to remove duplicate values in excelexcel pivot graphhow to convert xls to xmlvba copy sheet to new workbookwhat are dml statementsexcel activex controlexcel 2010 hlookupunhide workbook excel 2010vba call subduplicate entries in excelexcel vba userformlearn excel for beginnershow do you unhide cells in excelfont color excel vbaexcel xml file formatconcatenate function in excelexcel vba untiladding filters to excelsql interview questions and answers pdf for fresherstutorial on excel macroshow to fix row in excelhow to highlight columns in excelabsolute value vbaexcel vba eventsms access macros tutorialisna vlookupdml sql commandshow to copy a worksheet in excelhide column vbavba range sortusing the macro recorder record a macrounlock locked excel fileautofit excel 2013excel macro codingdelete row in excel vbaexcel create userformvba excel tablehow to delete empty rows in excelvba excel msgboxexcel dashboard creatoraccess vba checkboxlookup formula excelremove all hyperlinks excel 2007progress chart excel templatearrange numbers in ascending order in excelkpi dashboard examples excelhow to edit protected excel filemicrosoft excel exam questions and answerssubstitute function in excelsimple vb projects for beginnersproject delivery plan templatejoining cells in excelexcel vba rowsexcel 2007 userformsample project timeline templatehow to generate charts in excelaccess vba tutorialexcel vba clear contents of rangecreating if statements in excelexcel vba is nothingexcel worksheet tabs missing