Fill justify is a life-saver option. The single core motive to use fill justify in Excel is to merge the data from multiple cells into a single cell.
And, if you have any other idea to merge text into one cell, leave it. Fill justify is a better 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 can fill justify option is helpful for us to merge the data from multiple cells.
Below you have some text in three cells. But, if you look carefully the text in different cells is a single sentence. And, when we tried to combine them using merging 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 use combine text with fill justify.
- First of all, make sure that the column in which your text is captured is wide enough to store the entire text in a single cell.
- Now, select all the cells in which text is stored.
- Go to Home Tab -> Editing Group -> Fill -> Justify.
- Now, your selected data of multiple cells is converted into a single cell.
Shortcut Key
You can also use a shortcut key to apply to fill justify: Alt ➜ E ➜ I ➜ J
Important Points
- You can only merge the data which is in textual form. Numbers cannot merge into a single cell using fill justify.
- Only 255 characters can merge into a single cell. If you have more than 255 characters, the rest of the characters will not merge into the cell.
- The width of the column is a very important factor while using fill justify.
Related Tutorials
- Formula Bar in Excel
- Add a Header and Footer in Excel
- Show Ruler in Excel
- Fill Handle in Excel
- Format Painter in Excel
- Quick Access Toolbar in Excel
- Status Bar in Excel
- Insert Text Box in Excel
- Automatic Rolling Months in Excel
- Open Backstage View in Excel
- Activating the Dark Mode in Excel
- Get the Scroll Bar Back in Excel
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