How to Use Excel CHAR Function in Office 365? – [with Examples]
Tags: charfunctioninexcel, excelfunctions, excel, exceltutorials
Published: 2020-12-14 12:20:09

---
title: How to Use Excel CHAR Function in Office 365? – [with Examples]
published: true
date: 2020-12-12 04:51:59 UTC
tags: CHARFunctioninExcel,ExcelFunctions,Excel,ExcelTutorials
canonical_url: https://geekexcel.com/how-to-use-char-function-in-microsoft-excel-365/
---

## CHAR Function in Excel:

By the way, we all know the term **“CHAR”** which is comes from the word Character. Generally, it refers to the letters used in a word or a text string.

In this article, we will describe the **definition, basic syntax, and usage of the**  **CHAR function** in **Excel Office 365.**
## CHAR function – Definition:

The **CHAR Function** in Excel is used to **get a character by a specified number**. It converts the given **number into a character.** You can attain the **output as a character representation of the given number.** The given number should be **between 1 and 255**.

## Fundamental Syntax of CHAR Function:

The fundamental syntax of the **CHAR function** is,

```
**=CHAR(numbers)**
```

### **Argument Description:**

- **Number:** Get a character by a specified number. The number should be between 1 and 255.

## Practical Examples of CHAR Function:

Let’s look at some examples of **CHAR****  function** and analyze how to use it in Microsoft Excel.

### **Example 1:**

- Enter the input term in **cell B6.**
- The Output will be displayed in **cell D6.**
- There are **two ways** to enter the formula in Excel to calculate the Output, kindly refer to the below screenshots.

![Using formula 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_1-28.png)<figcaption id="caption-attachment-4580">Using formula 1</figcaption>

![Using formula 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_2-25.png)<figcaption id="caption-attachment-4583">Using formula 2</figcaption>

- **Press Enter** to display the **output.**

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_3-23.png)<figcaption id="caption-attachment-4584">Output</figcaption>

### **Example 2:**

- Here, the below screenshot explains the **different examples of CHAR Function** in Excel.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_1-29.png)<figcaption id="caption-attachment-4585">Example 2</figcaption>

**Example 3: Data Error**

- If you give the input as **above 255,** the value turns into an error because the CHAR Function deals with the number **between 1 to 255 only.**
- Refer to the below screenshot.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_4-21.png)<figcaption id="caption-attachment-4586">Example 3</figcaption>

## A short summary:

This article gives you clarification about the **definition, basic syntax, and usage of the CHAR function** in Microsoft Excel 365 with a few practical examples. Kindly drop your valuable **suggestions/queries** in the comment box & don’t forget to drop your **worthwhile Feedback**.

Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning with us!!

## Related Articles:

- **[YEAR Function in Excel ](https://geekexcel.com/how-to-use-year-function-in-excel-365/)**
- **[EDATE Function in Excel](https://geekexcel.com/how-to-use-edate-function-in-excel-365/)**
- [**MINUTE Function in Excel **](https://geekexcel.com/how-to-use-minute-function-in-excel-365/)
- [**WORKDAY Function in Excel **](https://geekexcel.com/how-to-use-workday-function-in-excel-365/)
- **[DATE Function in Excel](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)**
- [**LOWER Function in Excel **](https://geekexcel.com/how-to-use-lower-function-in-microsoft-excel-365/)
- [**NETWORKDAYS Function in Excel **](https://geekexcel.com/how-to-use-networkdays-function-in-ms-excel-365/)
- [**SUM Function in Excel **](https://geekexcel.com/sum-function/)
- **[TODAY Function in Excel](https://geekexcel.com/how-to-use-today-function-in-excel-365/)**
- [**ADD Function in Excel **](https://geekexcel.com/how-to-create-custom-add-function-in-excel-365/)
- [**DAYS360 Function in Excel **](https://geekexcel.com/how-to-use-days360-function-in-excel/)