Justify Command in Excel

This is an interesting application of one of the tools available in Excel! It helps you break the text string in a single line in multiple rows and vice versa

Assume that we have this text in different cells

 --> We want to bring this together in a single line

Sure, we can do this through the CONCATENATE function but there is a simple and smarter way to do it

Justify Command in Excel

1. Select the rows which have the text strings and now select the columns, wide enough to accommodate the text string in a single row
2. Go to the Home Tab and Select Justify under the Fill drop down
3. The strings in different rows will appear in a single row

It also works vice versa

--> Breaking a single line in rows

1. Select the row which has the text and multiple rows underneath which can accommodate the text (when split up in multiple rows) Tip : The text will be broken according to the width of the column, so if a column can accommodate 2 words, the Justify command will allow that
2. Once again go to the Home Tab and Select Justify under the Fill drop down
3. You will see that the single row text gets split into different rows

Other Interesting Excel Utilities

1. Screen Editing Options in Excel
2. 5 Crazy Tricks to help you save time
3. Unusual Shortcuts I use in Excel