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


Download Practice Workbook

Please download the practice workbook to practice yourself.


Introduction to CHAR(10) Function

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

Read More: Character Codes for CHAR Function in Excel (5 Common Uses)


3 Suitable Methods of Using CHAR(10) Function in Excel

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 Excel CHAR 10 Function with the necessary steps and illustrations.

Dataset of Excel CHAR 10


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 necessary illustrations.

Steps:

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

Applying Line Break to Use Excel CHAR 10 Function

  • Then, apply the following formula in the D6
="Reported"&CHAR(10)&" for"&CHAR(10)&" his behaviour"

Applying Line Break to Use Excel CHAR 10 Function

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

Applying Line Break to Use Excel CHAR 10 Function

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


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 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 address. Every address in this dataset is under the Line Break command. Let’s follow the steps described below.

Applying Line Break to Use Excel CHAR 10 Function

Steps:

  • Add a new column called Address.

Use Excel CHAR 10 Function to Replace Line Break

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

Use Excel CHAR 10 Function to Replace Line Break

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

Use Excel CHAR 10 Function to Replace Line Break

Use Excel CHAR 10 Function to Replace Line Break

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

Read More: How to Convert Excel ASCII to Char (An Easy Way)


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

Here, I will show how to use Excel Chart 10 Function to Add Two Strings. I consider 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 the D5.
  • Then, write down the following formula in it.
=B5&CHAR(10)&C5

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

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

Read More: How to Use Code 9 with Excel CHAR Function (2 Easy Examples)


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 skill. If you have any kind of questions. Feel free to ask me in the comment section.


Related Articles

Souptik Roy

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

Leave a reply

ExcelDemy
Logo