Concatenating Excel data with Fill Justify

This is one of those tips you may not know about, but it will be a lifesaver if you only have to use it once. Using the Fill > Justify feature in Excel, you can concatenate data from multiple Excel cells into a single cell. It’s easy, and here’s how it works…

Here I have a series of data cells that have text that I want to concatenate into a single cell. To start, I highlight all the cells I want to concatenate:

excel-filljustify-20190222-1

Next, I expand out the column to be wide enough to accommodate all the data. If it’s too short, it will break up the data into multiple cells in the column:

excel-filljustify-20190222-2

Now for the magic… select Home > Edit > Fill > Justify in the Ribbon Bar:

excel-filljustify-20190222-3

Yay! All the data is concatenated into a single cell, without you having to know any Formula language or wear out your fingers using copy/paste!

excel-filljustify-20190222-4

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s