Excel

Concatenate in one cell

What was the issue?

We have this cells and we need to get this info into one cell.

Like in this example.

We can use this function.

This function can take group of cells and give them in one string with specific delimitator.

What is CHAR(10).

This function creates line break. It can be used as delimitator.

Another necessary settings.

It is necessary to enable the “Wrap Text” button in the cells with concatenate informations.