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.


DOWNLOAD WORKBOOK

This is our text:

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

 

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

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

 

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