How to Use CHAR(10) Function in Excel (3 Practical Examples)

While working in Excel, sometimes you need to break your line or connect two strings to make your report or presentation more lucrative and presentable. To serve this kind of purpose you need to use the Excel CHAR 10 function. In this article, I am going to describe the CHAR 10 function as well as show 3 methods of its usage. So, without further delay, let’s jump into the descriptions.

Introduction to CHAR(10) Function

The CHAR function is a core Excel function. This function takes ASCII (American Standard Code for Information Interchange) code as an input. After that, it returns a symbol or character for that ASCII number. English letters, numbers, symbols, etc. are included in ASCII code. For example, you can add an asterisk (*) sign by writing the following equation.

CHAR 10 function returns a distinct value. This is the first value of the ASCII code. The CHAR 10 function returns a line break in Excel.

Syntax

The syntax of the Excel CHAR 10 function is given below.

=CHAR (10)

Argument

Read More: Character Codes for CHAR Function in Excel

How to Use CHAR(10) Function in Excel: 3 Practical Examples

Let’s consider a dataset on the Bill Report of ABC Company. The dataset has three columns B, C, and D naming Customer ID, Name, and Status respectively. The dataset ranges from B4 to D10. In this dataset the status of customer Penny is unknown and the status of customer Cathy is not available. From here, I will show you how to use the Excel CHAR 10 function with the necessary steps and illustrations.

1. Apply Line Break by Using CHAR(10) Function in Excel

In this part of this article, I will show the method of applying line breaks by using the Excel CHAR 10 function. Here I am going to describe the steps with the necessary illustrations.

Steps:

• Select the D6 and I will apply Line Break in this cell.

• Apply the following formula in cell D6.

• You will get the result just like the following picture.

Read More: [Fixed!] CHAR(10) Is Not Working in Excel

2. Use CHAR(10) Function to Replace Line Break

In this portion, I will show a method to replace the line break. I will use the Excel CHAR 10 function to follow the method. Here I have modified the dataset for your convenience, you can see it in the next picture. I have replaced the status column with an address. Every address in this dataset is under the Line Break command. Let’s follow the steps described below.

Steps:

• Add a new column called Address.

• Write down the following formula in cell E5.

• Then, you will find the result just like the picture given below.

• After that, Fill Handle the formula from cell E5 to E10.

• As a result, you will find the output like the picture shown below.

Read More: How to Convert Excel ASCII to Char

3. Add Two Strings by Inserting CHAR(10) Function in Excel

Here, I will show how to use the Excel CHAR 10 function to add two strings. I am considering another change of dataset. However, I will add the Customer ID and Name together in the D column. Let’s follow the steps one by one.

Steps: 

• Select cell D5 and write down the following formula in it.

• After that, Fill Handle the equation from cell D5 to D10.

• You will find the result just like the picture given below.

Read More: How to Use Code 9 with Excel CHAR Function

Things to Remember

• You should remember that if the formula does not work for Line Break in method 1, enable the Wrap Text option.

Download Practice Workbook

Please download the practice workbook to practice yourself.

Conclusion

In this article, I have tried to discuss the Excel CHAR 10 function. Hope you will understand the whole 3 methods and increase your Excel skills. If you have any kind of questions. Feel free to ask me in the comment section.

Related Articles

• How to Use CHAR(32) Formula in Excel
• How to Use CHAR(34) Formula in Excel
• How to Insert a New Line Using CHAR Function in Excel

<< Go Back to Excel CHAR Function | Excel Functions | Learn Excel