Excel 2016 for mac vba not working11/12/2023 ![]() Well the answer is quite simple but it can trouble experts sometimes. One of our users had a problem inserting a new line in a cell using the CHAR(10) formula. Example: Concatenate address lines with each line in a new line. In this article we will see why this happened and how you can make the CHAR(10) formula work. I have observed that sometimes the CHAR(10) formula does not seem to work. ![]() You will not need to use the ALT+ENTER shortcut to insert a new line. The CHAR(10) formula is used to insert a newline dynamically in a single cell. So in my previous article, I had told you how to use the CHAR(10). Activate the Wrap Text to make CHAR(10) formula work.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |