Excel Fill Justify to Merge Text from Multiple Cells to One Cell

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.

Quick Intro:

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.

Use Fill Justify in Excel To Merger Text Into one Cell

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

Use Fill Justify in Excel To Merger Text Into one Cell

How To Use

Follow these simple steps to use combine text with fill justify.

fill justify to replace with merging option
  • First of all, make sure that the column in which your text is captured is wide enough to store the entire text into a single cell.
  • Now, select all the cell 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 fill justify in excel: Alt E I J

Important Points

  1. You can only merge the data which is in textual form. Numbers cannot merge into a single cell using fill justify.
  2. Only 255 characters can merge into a single cell. If you have more than 255 characters, rest of the characters will not merge into the cell.
  3. The width of the column is a very important factor while using fill justify.


​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.

Content Protection by DMCA.com


  1. Gopal 20 Nov, 18 at 7:43 am - Reply

    Appears to be simple. Very Useful. Thanks Puneet.

  2. Rahul Rai 16 Jul, 18 at 1:18 pm - Reply

    Its only work for 2 cell, more than 2 cell, say three, its justify for 1st 2 cells

  3. KANTI DHAR DWIVEDI 29 Oct, 17 at 9:04 am - Reply

    How to create automatically columns based on range of two days?

  4. KANTI DHAR DWIVEDI 29 Oct, 17 at 9:02 am - Reply

    Thank you

  5. Emmanuel Martins Udu 8 Oct, 17 at 9:26 am - Reply

    Thanks Puneet

    • Puneet Gogia 8 Oct, 17 at 12:49 pm - Reply

      You’re Welcome

  6. Krupesh Daiya 7 Oct, 17 at 1:19 pm - Reply

    Yes learning something new every time I read your blog

    • Madhab Chandra Basak 8 Oct, 17 at 4:36 am - Reply

      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.

  7. yogirajoo 28 Sep, 17 at 7:43 am - Reply

    This Fill Justify is good option ! Thanks for bringing this up !!

    • Puneet 28 Sep, 17 at 8:14 am - Reply

      I.m glad you liked it.

    • Puneet 28 Sep, 17 at 8:15 am - Reply

      I’m glad you liked it.

    • Puneet Gogia 8 Oct, 17 at 12:48 pm - Reply

      You’re welcome.

  8. Missy Dubbs 8 Jun, 17 at 9:47 pm - Reply

    =A1&” “&A2&” “&A3

    • Puneet Gogia 9 Jun, 17 at 8:11 am - Reply

      Thanks Missy

    • Gaurav Singh 9 Jun, 17 at 10:57 am - Reply

      A1 A2 A3

  9. Brenda G 24 Feb, 17 at 11:26 am - Reply

    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!

    • Puneet Gogia 25 Feb, 17 at 6:10 am - Reply

      Hey Brenda, I’m so glad you liked it.

  10. indzara 28 Aug, 16 at 6:29 pm - Reply

    Thanks for sharing. I didn’t know about this option. Learning something new every day. 🙂

    • Puneet Gogia 25 Feb, 17 at 6:09 am - Reply

      Hey Dinesh, I’m so glad you liked it.

Leave A Comment