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

One of the most widely used applications in our day-to-day lives is the spreadsheet application Microsoft Excel. Excel was created solely with the intention of increasing user productivity. It works as expected most of the time, but in some cases, it may actually be to your disadvantage. You have come to the right place if you are looking for some unique solutions to the issue with the CHAR(10) function not working in Excel. This issue can be resolved in a number of different ways in Microsoft Excel. The issue will be addressed in three different ways in this article. Let’s follow the entire manual to learn everything.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article. It contains all the datasets and methods in different spreadsheets for a clear understanding.


3 SuitableSolutions If CHAR(10) Is Not Working in Excel

In the following section, we will use three effective and tricky solutions to fix the problem with the CHAR(10) function not working in Excel. This section provides extensive details on these solutions. You should learn and apply these to improve your thinking capability and Excel knowledge. We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference.


Solution 1: Use Wrap Text Command

Here, we’ll show you how to fix the problem with CHAR(10) not working in Excel. Excel occasionally fails to insert a line break when we attempt to use the CHAR(10). Let’s take a step-by-step look at the matter with proper illustrations.

  • First of all, we want to insert a line between each word by using the following formula.

=B5&CHAR(10)&C5&CHAR(10)&D5

  • Next, press Enter.
  • As a result, you will notice that there is no line break between words, indicating that the CHAR(10) function is not functioning properly.

use wrap text command to solve the problem of "CHAR(10) Function is Not Working in Excel "

  • Next, if you drag the Fill Handle icon to fill the other cells with the same formula, you will get the following output where Excel CHAR(10) is not working.

reason of the problem

To solve the problem, we’ll get the help of the Excel Wrap Text command. It’s simple & easy, just follow the following process.

📌 Steps:

  • First of all, select the range of the cells and go to the Home tab.
  • Then, select the Wrap Text command.

  • Now, you have to select the range of the cells C5:C9. Then, go to the Home tab, select Format, and finally, select AutoFit Row Height.

select Format option to solve the problem of "CHAR(10) Function is Not Working in Excel "

  • Eventually, you will be able to solve the problem and get a line break in an Excel cell as shown below.

show the output

Read More: How to Use CHAR(10) Function in Excel (3 Practical Examples)


Solution 2: Combine CONCATENATE with CHAR Function

Here, we will demonstrate another way to fix the problem. Here, we are going to combine CONCATENATE and CHAR functions to add new lines between words in Excel.  Let’s take a step-by-step look at the matter with proper illustrations when Excel fails to insert a line break if we attempt to use the CHAR(10) function

  • First of all, we want to insert a line between each word by using the following formula.

=CONCATENATE(B5,CHAR(10),C5,CHAR(10),D5)

  • Next, press Enter.
  • Therefore, you will notice that there is no line break between words, indicating that the CHAR(10) is not functioning properly.

combine concatenate and char (10) functions to solve the problem of "CHAR(10) Function is Not Working in Excel "

  • Next, if you drag the Fill Handle icon to fill the other cells with the same formula, you will get the following output.

To solve the problem, you will have to follow the following process.

📌 Steps:

  • First of all, select the range of the cells and go to the Home tab.
  • Then, select the Wrap Text command.

click on wrap text

  • Now, you have to select the range of the cells C5:C9. Then, go to the Home tab, select Format, and finally, select AutoFit Row Height.

  • Eventually, you will be able to solve the problem and get a line break in an Excel cell as shown below when Excel CHAR(10) is working properly.

show the output

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


Solution 3: Use TEXTJOIN with CHAR Function

We will illustrate yet another approach to fix the problem with the CHAR(10) not working in Excel in this section. To add new lines between words in Excel, we are going to combine the TEXTJOIN and CHAR functions here. Let’s take a look at the situation one step at a time with appropriate examples of when Excel fails to insert a line break when we use the CHAR(10) function.

  • First of all, we want to add a line between each word by using the following formula.

=TEXTJOIN(CHAR(10),TRUE,B5,C5,D5)

  • Next, press Enter.
  • Therefore, you will notice that there is no line break between words, indicating that the CHAR(10) function is not functioning properly.

use textjoin and char(100 functions to solve the problem of "CHAR(10) Function is Not Working in Excel "

  • Next, if you drag the Fill Handle icon to fill the other cells with the same formula, you will get the following output.

To solve the problem, you will have to follow the following process.

📌 Steps:

  • First of all, select the range of the cells and go to the Home tab.
  • Then, select the Wrap Text command.

select wrap text option

  • Now, you have to select the range of the cells C5:C9. Then, go to the Home tab, select Format, and finally, select AutoFit Row Height.

click on Format option to fix the problem with the CHAR(10) function not working in Excel

  • Eventually, you will be able to solve the problem and get a line break in an Excel cell as shown below when Excel CHAR(10) function is working properly.

show the output

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


Conclusion

That’s the end of today’s session. I strongly believe that from now, you may fix the problem with the CHAR(10) function not working in Excel. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website ExcelDemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib

Saquib

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo