Merging cells with delimiter in MS Excel

Faced with the process of importing data with csv files, one has to deal with excel. Below is a small note on how to combine multiple cells with a separator.

Let us have, for example, 3 columns with links to images that need to be combined into one column with a separator between them.

Excel

We use a small formula

=A2&", "&B2&", "&C2

and use it in cell D2

Excel

Excel

As you might guess, the separator is set in quotes and can be whatever you need.

In the end, it is worth noting that if you just want to copy this column, then only the formula will be copied from you. In order to leave only the value of the result of the execution of the formula, i.e. merged cells, you need to select the desired range, make a copy, go to the cell to paste, right-click and in the extended paste menu select paste the value with this icon

Excel

Now you will have values ​​in the cells with which you can work in the future.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
The comment language code.