Is it possible to insert a new row inan Excel cell? Many people think of Microsoft Excel as an extended calculator but if you’ve dug into it a little bit you know it is much much more than that. To be honest I use Excel even when I should have been using Word instead. Of course, when writing a text document normally MS Word should be the first hand option, but if your text is possible to organize and structure in a spreadsheet Excel is number one.
Insert a row in an Excel cell – example
Sometimes you need to insert a row in an Excel cell. It is not obvious how to do this. The best way I have found is the following.
I have a list of famous people and their profession. I’d like to have both the name and profession in the same cell. I would also like to have the name on one line and the profession on another.
This is what I have:
This is what I want:
This is a great way to solve it:
By using the & symbol you join the result of formulas in a cell and text in a new cell. By using CHAR(10) you add the new line or new row I needed. Hope it helps you to!