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