Free Practice WorkbookTable of Contents
Excel´s Fill Justify Tool
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 workbookFill-Justify.xlsx
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!
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.
30 Days - Full Access 
