If you want the entire Long-term debt account listed on row 7, simply select cells A7:A8. Go to Home on the Ribbon, go to the group Editing, click the dropdown arrow next to Fill, and choose Justify.

When you need to format text in multiple ways in a single cell in Microsoft Excel, then this guide shows you how to do it the easy way.

If you cannot insert, add or create new cells in worksheets in Microsoft Excel, remove cell protection and unmerge the Rows to begin with.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.