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

Fill Justify

HELPFUL RESOURCE:

728x90

 

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

Share on Google+

Related Posts

Remove Duplicates in an Excel Table When you have duplicates values within your Excel Table there is a quick and easy way to remove those values.The duplicate values could be all over your Excel Table and sometimes it takes valuable time trying to locate those duplicates and then deleting them.Not to worry,...
Show The Percent of Parent Row Total With Excel Pi... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT ROW TOTAL calculation.This is a new calculation in Excel 2010 and onwards.This option will immediately calculate the percentages f...
Free Excel Templates If you want ready made custom Excel templates then you do not have to pay for them as they are FREE inside your Excel workbook!To activate this you need to go to File > New and choose from a variety of categories, such as:Budgets, Planners, Lists, Invoices, Calendars, ...
Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list.A dynamic drop down list expands as the Excel Table expands when new data gets added to it.This is great when you want to have users select from a predefined ...