Wendy has attended:
Excel Introduction course
Grouping email addresses in different cells into one cell
I have forgotten how to grab email addresses populated in different cells, to group them in one cell and separating them by semi-colon (;). I'd be grateful for a reminder on how to do this.
Thanks!
RE: 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
