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

excel formulas with examples in excel sheetdelete rows in excelexcel vba rows countdcl definitionwhat is vlookup excelwhere is developer tab in excel 2013sas programming for dummiesexcel worksheet vbavba workbook objectswot analysis template excelfind duplicates in excel vbaexcel vba print commandadd developer tab to ribbon word 2010unprotect worksheet excelexcel project management dashboardbar chart schedule in excelconvert xml to xlsxcan you unprotect an excel spreadsheetunhide hidden workbookhow to enable developer in exceljob tracking spreadsheet templatevba insertvba string integerexamples of ddlform control vs activex controlhow to use pivot tables excel 2010refresh all pivotsexcel vba end of columnexcel vba copy worksheetexcel programme templatehow do i merge and center in excelexcel vba choosecharting with excelfree manpower planning template excelstep vbadebug.print vbadefine macros in excelexcel substitute examplevba and macroswhat does sub mean in vbaunprotect worksheet excelsql queries asked in interviews pdfexcel 2010 stacked bar chartfilter pivot table based on cell valueexcel count duplicatesddl and dml commands in sql with examplesvba for microsoft wordexcel msgbox yes nomacros in excel sheetvba and sqlbuilding estimation excel sheethow do i remove hyperlinks in excelexcel macro windows activatex1up vbalistbox selecteditemsaccess messageboxwhat is a pivot table in excel used forhow to record macro in excel 2007excel vba worksheet activatevlookup for dummies 2010ms excel hyperlinkfso.copyfileeasy excel vbaenableevents vbahow to unhide cells in excel 2013excel 2007 vlookup exampleformat vba codemacro protect sheetfor each vba excelvba name rangemessagebox buttonsexcel hidden columnhow do i get rid of extra pages in excelrecord macro in excel 2007vba scriptsddl and dml commandsinsert excel buttonascending order worksheetsexcel control commandsmsgbox accessformat vba