Grouping email addresses in different cells into one cell

Hi Wendy,

Thank you for your post. Here is a possible solution:

Say your email addresses are in column A:
A
--------------------
1 alice@example.com
2 bob@example.com
3 charlie@example.com
4 dave@example.com

Set cell B1 to =A1
A B
-------------------- ---------------------
1 alice@example.com alice@example.com
2 bob@example.com
3 charlie@example.com
4 dave@example.com

Now set cell B2 to =B1 & ";" & A2
A B
-------------------- ---------------------
1 alice@example.com alice@example.com
2 bob@example.com alice@example.com;bob@example.com
3 charlie@example.com
4 dave@example.com

Now fill down cell B2
A B
-------------------- ---------------------
1 alice@example.com alice@example.com
2 bob@example.com alice@example.com;bob@example.com
3 charlie@example.com alice@example.com;bob@example.com;charlie@example.com
4 dave@example.com
alice@example.com;bob@example.com;charlie@example.com;dave@example.com

Keep filling down to the end of your list of emails.

The last cell in column B will contain all the email addresses with semicolons inbetween.

I hope this helps.

Kind regards
Marius Barnard
Excel Trainer