• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel CHAR Function

You are here: Home / Excel Functions / Excel CHAR Function

The Excel CHAR Function returns a character based on its Windows-1252 character number. It's handy for inserting characters or punctuation into text strings, or for converting codes you might get from other computers into characters.

It’s also a clever way to clean or remove non-printing characters when used with the SUBSTITUTE function.

Excel CHAR Function Syntax

Syntax:  =CHAR(character number)
 

Excel CHAR Function Arguments

character number a number between 1 and 255 that specifies the character you want returned based on its Windows-1252, or Mac OS character number.
 

Download the Workbook

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Excel Workbook. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.

Excel CHAR Function Examples

Excel CHAR Function

*Line Break: The line break character, 10, requires the cell to be formatted with Wrap Text to force the text onto the next line.

Excel CHAR Function Tips and Notes

Excel Online: Only supports characters 9, 10, 13 and 32 and above.

Tips:

  1. The lowercase alphabet can be determined by adding 32 to the capital letter number. e.g. the letter 'A' is number 65 and the lowercase letter 'a' is number 97.
  2. You can use the CODE function to find out a character number for use in the CHAR function. E.g. =CODE("M") returns the number 77.
  3. The first character numbers 0 to 31, excluding 12 are non-printing, meaning Excel can’t display them. Instead you’ll see a rectangle placeholder, as shown in cell F15 of the screenshot above.

MAC Users: You will find some of the character numbers are different. e.g. a line break on a Mac is character number 13, whereas in Windows it's 10. See link below for Mac OS character number list.

Character Lists for use with Excel CHAR Function

Below are links to Wikipedia where you can find lists of the various character numbers for Windows and Mac Operating Systems.

Windows-1252 Character List

Mac OS Roman Character List

PC Character Map: You can also find the character numbers in the Character Map on your PC.

To open the Character Map, simply type CharMap into the Windows search box or Cortana. Locate the character you want to use in the dialog box and you’ll see the character number in the bottom right:

PC Character Map

Got Questions on the CHAR Function

Please ask them on our Excel Forum where our experts are ready to help.

Excel CHAR Function Formula Examples

Remove non-breaking spaces from text

Force text to wrap without using CHAR(10)

Force Chart Axis Labels to wrap

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.