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.