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

Get FREE Advanced Excel Exercises with Solutions!

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(42)`

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

Argument Required or Optional Value
10 Required Returns the Line Break Command

## 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.
`="Reported"&CHAR(10)&" for"&CHAR(10)&" his behaviour"`

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

### 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:

• Write down the following formula in cell E5.
`=SUBSTITUTE(D5,CHAR(10),CHAR(44))`

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

• 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 Chart(10) Function in Excel

Here, I will show how to use the Excel Chart 10 function to add two strings. I am considering another change of dataset. However, I will add 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.
`=B5&CHAR(10)&C5`

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

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

## Things to Remember

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

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

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF