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 |
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.
="Reported"&CHAR(10)&" for"&CHAR(10)&" his behaviour"
- 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.
=SUBSTITUTE(D5,CHAR(10),CHAR(44))
- Then, you will find the result just like the picture given below.
- After that, Fill Handle the formula from 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 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.
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.