An interesting tool within Excel is the Fill Justify.  It allows you to select text from several rows and merge them in to one cell.

So if you have data that gets downloaded in to separate rows and want to join them up in to one sentence, then the Excel´s Fill Justify option is your savior.

See the short gif below to see how easy it is to implement.

Excel´s Fill Justify Tool | MyExcelOnline
DOWNLOAD WORKBOOK

This is our text:

Excel´s Fill Justify Tool | MyExcelOnline

STEP 1: Adjust your column width so all the text could fit in one cell

Excel´s Fill Justify Tool | MyExcelOnline

 

STEP 2: Select the cells that you want to combine together. Go to Home > Fill > Justify

Excel´s Fill Justify Tool | MyExcelOnline

With just that, everything is now combined into one single cell!

Excel´s Fill Justify Tool | MyExcelOnline

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Excel´s Fill Justify Tool | MyExcelOnline