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

Below is a dataset on the Bill Report of ABC Company. The dataset has three columns: Customer ID, Name, and Status. Penny’s status is unknown, and Cathy’s statusÂ is not available.

### Method 1 â€“ Applying a Line Break Using the CHAR(10) Function

Steps:

• Select cell D6 and apply a Line Break.

• Enter the following formula in cell D6:
`="Reported"&CHAR(10)&" for"&CHAR(10)&" his behaviour"`

• The result should look like the following picture.

### Method 2 â€“Â  Replacing a Line Break Using the CHAR(10) FunctionÂ

In the modified dataset, the status column was replaced with an address. Every address in this dataset is under the Line Break command.

Steps:

• Add a new column called Address.

• Enter the following formula in cell E5:
`=SUBSTITUTE(D5,CHAR(10),CHAR(44))`

• The result should look like the picture below.

• The result should look like the picture below.

Read More: How to Convert Excel ASCII to Char

### Method 3 â€“ Adding Two Strings Using the CHAR(10) FunctionÂ

Steps:Â

• Select cell D5 and enter the following formula:
`=B5&CHAR(10)&C5`

• Fill Handle the equation from cell D5 to D10.

• The result should look like the picture below.

Download the Practice Workbook

Download the practice workbook to practice yourself.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF