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 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 want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.