Forum Discussion
How to insert paragraphs within a Cell in Excel
Can anyone PLEASE tell me if there is an easy way to combine Columns A and B to look like what I have in E1 and E2? I used the concatenate formula to combine the two cells but I need the Entity/Insti...
Thank you for the speedy reply!! SergeiBaklan
How did you know what "Enter" is!? Is there a list I can access for referencing what each command is?
There are ASCII nonprinting control characters, last table here https://support.office.com/en-us/article/insert-ascii-or-unicode-latin-based-symbols-and-characters-d13f58d3-7bcb-44a7-a4d5-972ee12e50e0.
new line/line feed has code 10. In Excel the to return character by its code will be CHAR(10).