Widen the column so the combined text fits in one cell, then select the text cells in that column and go to Home → Editing → Fill → Justify. The text from every selected cell moves into the top cell, separated by spaces, and the cells below are emptied.
From the keyboard, the ribbon key tips should be Alt, H, F, I, J, pressed one after another. The older Excel 2003 menu sequence Alt, E, I, J may also still work. Test both in your version before relying on them.
If the column is too narrow, Excel spreads the text over as many cells as the width needs instead of one. The same command works in reverse: narrow the column, select a long-text cell plus empty cells below it, and Justify splits the sentence into lines that fit.
Fill Justify works only on typed text in a single column. It won’t combine cells across a row, it skips numbers and formulas, and the result is fixed text that doesn’t update when the source changes.
To keep the original cells and get a result that updates, use a formula instead: =TEXTJOIN(" ",TRUE,A1:A3) in Excel 2019 and Microsoft 365, or =A1&" "&A2&" "&A3 in any version. TEXTJOIN also works on a row, such as A1:C1.
Fill justify is a life-saver option. The main reason to use fill justify in Excel is to merge the text from multiple cells into a single cell.
There are other ways to merge text into one cell, but for a few cells of text, fill justify is the quickest option. So today, in this post, you will learn how to merge text from multiple cells into a single cell using fill justify.
So let’s get started (it’s one of those Excel Tips that can help to get better at Basic Excel Skills).
Quick Intro:
Let’s take an example to understand how the fill justify option helps you merge the data from multiple cells.
Below you have some text in three cells. But if you look carefully, the text in the different cells is a single sentence. And when we tried to combine them using Merge & Center, we just got the text from the first cell.

But by using fill justify, you can combine all the text, just like below.

How to use
Follow these simple steps to combine text with fill justify.
- First of all, make sure that the column in which your text is stored is wide enough to show the entire text in a single cell.
- Now, select all the cells in which the text is stored (one column only).
- Go to Home Tab -> Editing Group -> Fill -> Justify.
- Now, the text from the selected cells is combined into the first cell, and the other cells are cleared.

Shortcut Key
You can also use a shortcut key to apply fill justify: Alt ➜ E ➜ I ➜ J
This is the old Excel 2003 menu shortcut, which still works. The ribbon shortcut in current versions is Alt ➜ H ➜ F ➜ I ➜ J (Home ➜ Fill ➜ Justify).
Important Points
- You can only merge the data which is in text form. Numbers and formulas can’t be merged into a single cell using fill justify.
- Only 255 characters can be merged into a single cell. If you have more than 255 characters, the rest of the characters will not be merged into the cell.
- The width of the column is a very important factor while using fill justify.
Split Long Text into Multiple Rows
Fill justify works the other way as well. If a cell has a long sentence and the column is narrower than the text, Justify splits the text into several cells, one below the other, based on the column width.
- First of all, make the column as wide as you want each line to be.
- After that, select the cell with the text and the empty cells below it.
- In the end, go to Home ➜ Editing ➜ Fill ➜ Justify.
If you don’t select enough empty cells, Excel shows a “Text will extend below selected range” message. Click OK to let it use the cells below, but make sure those cells are empty, as Excel overwrites them.
Other Ways to Combine Text from Cells
Fill justify changes the cells themselves and only works with text in one column. When you want to keep the original cells, or combine numbers too, use a formula instead. In Excel 2019 and later, TEXTJOIN joins a range with a space between the values and skips empty cells:
=TEXTJOIN(" ",TRUE,A1:A3)
In older versions, join the cells with the ampersand:
=A1&" "&A2&" "&A3
Frequently Asked Questions
Does fill justify work with numbers or formulas?
No, it only combines text. To join numbers or the results of formulas, use TEXTJOIN or the ampersand formula shown above.
Why did fill justify not combine all my text?
The column isn’t wide enough for the combined text, so Excel fits as much as it can in each cell and leaves the rest in the cells below. Make the column wider and use Justify again.
Can I undo fill justify?
Yes, press Ctrl + Z right after you use it to get the text back in the original cells.
Grear it work
easy and nice. Tks.
Thank YOU
Welcome
Thanks for sharing, it’s very helpful.
Very useful thank you
Appears to be simple. Very Useful. Thanks Puneet.
Its only work for 2 cell, more than 2 cell, say three, its justify for 1st 2 cells
Make sure to apply enough width to the column so that the text from all the cell (3) can be combined into one cell. Learn more from here https://excelchamps.com/formulas/concatenate-a-range-of-cells/
Great tip of which I was not aware. Thank you
How to create automatically columns based on range of two days?
Thank you
Thanks Puneet
You’re Welcome
Yes learning something new every time I read your blog
On scrutiny I found :
1. Merging using this system does not work if the consecutive cells having text contents are in a row
2. When the cells are in a column it works but up to that extent that the column with can hold data
However thank you for this new and useful tips for merging cells.
Yes, we need to take care for column width, other wise it merge text up to the length of the cell and for row here are some methods I have collected ==> https://excelchamps.com/formulas/concatenate-a-range-of-cells/
This Fill Justify is good option ! Thanks for bringing this up !!
I.m glad you liked it.
I’m glad you liked it.
You’re welcome.
=A1&” “&A2&” “&A3
Thanks Missy
A1 A2 A3
I’ve been using Excel for nearly 20 years, Puneet, yet had no idea that this feature existed. Thank you again for all you do!
Hey Brenda, I’m so glad you liked it.
Thanks for sharing. I didn’t know about this option. Learning something new every day. 🙂
Hey Dinesh, I’m so glad you liked it.
It’s amazing. Thanks