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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

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:

CHAR(number)

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-Ascii

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

Dim sOutout As String
sOutout1 =CHR(80)

Output: P

LIMITED TIME OFFER
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


countif vba excelminimise shortcut keyexcel vba select columnexcel vba selectexcel vba copy fileexample of vlookupvba excel waithow to open excel vbahow to cut a cell in half in excellistbox exceldata control language in sql with examplesimple excel commandsexcel vba unload medelete duplicate datasql update vbaproject management tracker excelconstruction cost template excelhow do i unhide a column in excelwhat is an operandhide excel cellsexcel interactive graphhide columns excelexcel vba file openhow to protect a workbook in excel 2007controls for vbaexcel vba rowsms excel macrovba data entry formoffset meaning in hindiexcel macro stringexcel vba code if then statementexcel vba autofiltervba matchproject management gantt chart exceloption button excel vbacopy range vbadashboard templates for excelvba excel templatesbreak excel workbook passwordvb6 backcolorunprotect excel sheet 2007excel remove duplicate columnsexcel password protect sheetworksheet on coloursuseful excel macrosmicrosoft estimate templatems excel vba tutorialvlookup fixed rangecreating dynamic charts in exceltimevalue vbaunprotect excel workbook 2010 with passwordexcel how to write a macroestimating templateshow to unlock excel sheetopen xlsx file with excel 2003excel sumif exampleaccess 2007 msgboxproject management dashboard excel templateexcel linked cellsvba nested for loopvba find last row with datavba open file dialogvba close formvba update queryadvanced excel vba examplesvb6 checkboxdefine activexexcel easy vbasql technical interview questions and answers pdfexcel vba select multiple rowsisna excel formulamacro to delete duplicate rows in excelweekly status report template wordunhide rowsusing lookup in excel