Excel CHAR(10) Not Working. How to Solve It?

Activate the Wrap Text  to make CHAR(10) formula work.

So in my previous article, I had told you how to use the CHAR(10). The CHAR(10) formula is used to insert a newline dynamically in a single cell. You will not need to use the ALT+ENTER shortcut to insert a new line. I have observed that sometimes the CHAR(10) formula does not seem to work. In this article we will see why this happened and how you can make the CHAR(10) formula work.

Example: Concatenate address lines with each line in a new line.

One of our users had a problem inserting a new line in a cell using the CHAR(10) formula. But it was not working. He shared the sheet and asked for help.

Here is the formula he used:

=A2&CHAR(10)&B2&CHAR(10)&C2&CHAR(10)&D2&CHAR(10)&E2&CHAR(10)&F2&CHAR(10)&G2

And here's the result.

It doesn't seem to work. Does the formula have a problem? No. So why is CHAR(10) not working? 

Well the answer is quite simple but it can trouble experts sometimes. 

Solution:

To CHAR(10) work, you need to activate the word wrap. In home tab --> alignment section - word wrap. Click on this option and you will see the CHAR(10) working successfully.

So yeah guys, this is how you can make CHAR(10) formula work. I hope it was helpful. If you have any doubt regarding this article or have any other questions related to Excel or VBA, ask in the comment section below. I'll be happy to answer any questions.

Related Article:

Excel New Line In Cell | Many times we want to write in a cell with a new line. We try to hit ENTER key but cursor moves to a new cell instead of entering a New Line In Excel Cell. So how to add lines in excel cell or say an add line break in excel cell?

How to use the CHAR Function in Excel | The Excel CHAR function is used for converting a number code into its character. Each character in excel has the number code. To convert code into its equivalent text we use CHAR function.

Split a Cell Diagonally in Microsoft Excel 2016 : To split cells diagonally we use the cell formatting and insert a diagonally dividing line into the cell. This separates the cells diagonally visually.

How do I Insert a Check Mark in Excel 2016 : To insert a checkmark in Excel Cell we use the symbols in Excel. Set the fonts to wings and use the formula Char(252) to get the symbol of a check mark.

How to disable Scroll Lock in Excel : Arrow keys in excel move your cell up, down, Left & Right. However, this feature is only applicable when Scroll Lock in Excel is disabled. Scroll Lock in Excel is used to scroll up, down, left & right your worksheet not the cell. This article will help you with how to check scroll lock status and how to disable it?

What to do if Excel Break Links Not Working : When we work with several excel files and use formulas to get the work done, we intentionally or unintentionally create links between different files. Normal formula links can be easily broken by using the break links option.

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity | Get faster at your task. These 50 shortcuts will make you work even faster on Excel.

How to use Excel VLOOKUP Function| This is one of the most used and popular functions of excel that is used to look up value from different ranges and sheets.

How to use the Excel COUNTIF Function| Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.

How to Use SUMIF Function in Excel | This is another dashboard essential function. This helps you sum up values on specific conditions.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.