EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources TEXT and String Functions in Excel Excel CHAR Function
Secondary Sidebar
Excel Functions
  • TEXT and String Functions in Excel
    • Excel CODE Function
    • Excel Find
    • TRIM Formula in Excel
    • Excel CHAR Function
    • LEFT Formula in Excel
    • Opposite of Concatenate in Excel
    • Concatenate Strings in Excel
    • Extract Numbers From String
    • VALUE Formula in Excel
    • Left TRIM in Excel
    • Substring Excel Function
    • SUBSTITUTE Function in Excel
    • Excel VALUE Function
    • Excel REPT Function
    • Excel TRIM Function
    • Excel CLEAN Function
    • Excel EXACT Function
    • PROPER Function in Excel
    • Excel LEFT Function
    • MID Function in Excel
    • LEN Function in Excel
    • CONCATENATE Function in Excel
    • SEARCH Function in Excel
    • RIGHT Function in Excel
    • FIND Function in Excel
    • TEXT Function in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Online COURSE
  • Online Excel Data Analysis Training

Excel CHAR Function

By Madhuri ThakurMadhuri Thakur

CHAR Function in Excel

CHAR Function in Excel (Table of Contents)

  • CHAR Function in Excel
  • How to Use CHAR Function in Excel?

CHAR Function in Excel

CHAR means CHARACTER. In Excel CHAR, the function is a TEXT formula that returns the character, which is specified by the numbers from 1 to 255. These characters are inbuilt by Microsoft based on the numbers that we supply. It is very useful to insert characters to our strings while writing something. These characters ordinarily cannot type from our normal keyboard. Instead, we need to use the CHAR function.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

CHAR Formula in Excel:

The CHAR Formula in Excel is as follows.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,898 ratings)

CHAR Formula

The Formula of CHAR function involves only one argument, i.e. number

Number: It is the integer number ranging from 1 to 255.

This argument can be given cell reference as well as direct supply to the argument. Since we only need to supply numbers as an argument, we need not specify the number and double-quotes.

How to Use CHAR Function in Excel?

This CHAR is very simple easy to use. Let us now see how to use the CHAR Function in Excel with the help of some examples.

You can download this CHAR Function in Excel Template here – CHAR Function in Excel Template

Example #1

Firstly, we need to look into which number specifies which character. The below list tells the associated character for each number.

CHAR Example 1

CHAR number 1 unleashes nothing, i.e. empty cell but only for the outset. There is always a character in it. You can use the LEN formula to check.

CHAR Example 1.1

Example #2

Assume you are working in a college as an assistant. You have a list of all the students, and you need to post the attendance report to their respective homes. You have addressed in three different columns, and you need to merge those 3 into 1 column and insert line breakers after each and every column.

Example 2

In column G, you need to combine the full address by giving a line breaker after each address. We can insert the line breaker by using the CHAR function. Important to know which number we need to use to insert a line breaker. Number 10 we need to use to insert the line breaker after each address column.

CHAR Example 2.1

Initially, our data looks like this. One tuning we need to do here. The tuning is we need to wrap the text to see the difference.

CHAR Example 2.2

Now, see how your address column looks.

Example #3

We can insert alphabets by using the CHAR function. Below are the lists of numbers to insert the alphabets.

Example 3 (table)

Apply these codes in excel to see the magic.

CHAR Example 3.1

Now we have inserted UPPER case alphabets. In order to insert the LOWER case alphabets, we need to use the below codes.

CHAR Example 3.2

Example #4

We can insert those CHARACTERS by using the keyboard too. Below is the list of those keys.

Example 4

Example #5

Assume you have downloaded the below data from the web, and you need to remove all those line breakers and special characters from this.

Example 5

In order to remove those special characters and remove line breakers, we can use the SUBSTITUTE function.

CHAR Example 5.1

We have used a three-nested SUBSTITUTE function to remove special characters and line breakers.

Things to Remember

  • CODE function can return the number if you give the special character as a reference. For example, =CODE (“A”) will return 65 as the answer.
  • The first 32 characters are non-printable characters that can be removed by using a CLEAN function in excel.
  • We can insert the characters by using ALT + numbers instead of the CHAR formula.
  • If the supplied number is not triggered, then we will get #VALUE! Error, i.e. numbers more than 255.
  • If the supplied is the number is not in the numeric format, we will get the same error.

Recommended Articles

This has been a guide to CHAR Function. Here we discuss the CHAR Formula and how to use CHAR Function in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  1. MID Function in Excel
  2. SEARCH Function in Excel
  3. Logical Function in Excel
  4. Time Function in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
2 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download CHAR Function in Excel Template

EDUCBA

Download CHAR Function in Excel Template

EDUCBA

डाउनलोड CHAR Function in Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more