How to concatenate a list of data in Excel

Today we will explain how to concatenate a list of data in excel. For the concatenation exercise we have a list with 350 emails, to which we want to send an email and we need to collect them in one mailing.

We know that to send an email to the list, we should separate the emails we have with a semicolon (;) so that the postal operator will recognize it. So we have to find a way to do that concatenate the list in a single semicolon-separated cell.

The normal thing we could do is concatenate them and go and manually select each data to form the concatenated list into one. But this would require a little more work and a lot more time considering that there are 350 emails that we have to concatenate.

Let's see it in a formulated way, which in a few seconds will allow us to have our list of data in Excel completely concatenated.

Index of contents

How to concatenate in Excel

So how do you concatenate two cells? There are two ways, one is to use the concatenated function which is basically this (CONCATENATE(text1; (text2); ...)), but a great option or strategy to use is with the Asper sign (&).

For example, we are going to concatenate with the ampersand &, we put = and select cell A2, ampersand & and the cell we want to concatenate with, we are left with something like (=A2&B1) in this way we concatenate the cells.

This option is pretty much the same as using the formula, it's much easier and much faster, it's pretty much just a matter of taste and to use the formula you identify with the most.

You may also be interested in: Advanced Filters in Excel

Easiest way to concatenate in Excel

We are going to concatenate our list by doing an incremental concatenation. Therefore, we will place our separator (semicolon) in another column and set it in our concatenation formula in excel


Let's start using ours concatenated formula. We stop at cell B3 and say it is equal to the concatenated (&) cell A3 since it is separated by a semicolon, we select the (;) which is in cell C1 of our concatenation exercise. We fix cell C1 with F4 $C$1, write concatenate (&) again and select the other cell for our exercise, which would be A2.

In row B3 we already have the email which is in cell A2 and A3 concatenated. Now what we do in row B4 is select the two values ‚Äč‚Äčthat we have already concatenated in cell B3, put Asper (&) to concatenate and go back and select the semicolon (;) of cell C1 and put & again and select the cell A4 which is the one we need to add to our concatenation.

concatenation in excel

Now let's copy the formula and replicate it on all rows up to 350 and paste the last row as a value, now we can delete the other rows, without going to delete the one in row 350, which is our concatenation result where we have our 350 emails separated by semicolons.



This is a very simple option for concatenate in excel and in which it took a few seconds to do so. Now we can copy all the concatenated emails and paste them into the recipient of the email we need to send.

concatenation function in excel

Here we have the easiest way to concatenate in excel a list of data or a list of records.

We hope the Excel tutorial of today, it can serve not only for chain mailing lists. But also to manage some other type of queries that can be made in ERPs such as codes or other data where the same mechanics of concatenate.

Leave a Reply

Your email address will not be published. Required fields are marked *

Go up Change privacy settings