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/Institution under the name within the cell. Some have 2 institutions and will need
You may use CHAR(10) in concatenation instead of space like
=A2 & CHAR(10) & B2Wrap text shall be applied to resulting cells (select entire column, Ctrl+1, Alignment, check Wrap Text box).
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).
