Excel How To Merge Cells Into Single Cell Separated By Comma

Do you like this?

Summary:
I have done this trick a number of times but never thought it would be useful to someone until my friends asked me how to do it. Suppose you have a list of email addresses which you are going to send email to. You want to combine the cells into a single cell with email addresses separated by comma so that you can put it into the Send To field in Outlook.


Content:

You can use the same trick with different delimiters such as semicolon, period or even dash.

This is how your list might look like at the beginning:
Excel Merge Cells Separated Comma - Step sshot-1.jpg

We will use the next column for combining the cells. For the first row we have to keep the same value as that of the cell on the left hand side:
Excel Merge Cells Separated Comma - Step sshot-2.jpg

For the second row, we will combine the value from the cell of the upper row and the cell on the left hand side.
Excel Merge Cells Separated Comma - Step sshot-3.jpg

Next, we need to copy the formula down to the lower rows:
Excel Merge Cells Separated Comma - Step sshot-4.jpg

The cell on the last row and on the right hand side contains all the separated email addresses as we wanted. We can copy the data and remove all the formulas if required.
Excel Merge Cells Separated Comma - Step sshot-5.jpg

 
comments powered by Disqus