Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
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.
Let’s take an example to understand that 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 first cell.
But by using fill justfy, you can combine all the text, just like below.
Follow these simple steps to use combine text with fill justify.
You can also use a shortcut key to apply fill justify in excel: Alt E I J
If you don't want get your hands dirty with formulas, then fill justify is the best option to merge text from different cell.
The best thing is you just need few clicks.
I hope you found this tip super useful.
Now, tell me one thing. Do you have any other method to combine text from different cells. Share with me in the comment section, I would love to hear from you.
And, please don't forget to share this tip with your friends.