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.

Dataset of Excel CHAR 10


Method 1 – Applying a Line Break Using the CHAR(10) Function

Steps:

  • Select cell D6 and apply a Line Break.

Applying Line Break to Use Excel CHAR 10 Function

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

Applying Line Break to Use Excel CHAR 10 Function

  • The result should look like the following picture.

Applying Line Break to Use Excel CHAR 10 Function


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.

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

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

Use Excel CHAR 10 Function to Replace Line Break

  • The result should look like the picture below.

Use Excel CHAR 10 Function to Replace Line Break

Use Excel CHAR 10 Function to Replace Line Break

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

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


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

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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo