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:

Add a new row in and show result in a new cell

This is what I want:

Add a new row in and show result in a new cell

This is a great way to solve it:

 

Add a new row in and show result in a new cell

 

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!

 

 

 

 

 


Leave a Reply

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