• Excel Development Tips Merge Text

  • Merge Text - Excel Development from Xlteq

    Have you ever wanted to merge the contents of several cells into a single cell?

    This can be done quite easily by using Fill – Justify.

     

    Merge Text 1

     

    First of all, make sure the column of data is wide enough so that the entire text can be combined into one cell.

    Select the range of cells to be combined, then on the Home tab, select: Editing – Fill – Justify

     

    Merge Text 2

     

    The cells will be combined and entered to the first cell of the range.

     

    Merge Text 3