Excel Development Tips Merge Text

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.

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

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