Hi

I have an excel sheet with multiple columns

In one column I have a bunch of email addresses (and another with phone numbers) say Column G.

Example
a@a.com
b@b.com
c@c.com

I need to be able to select the cells with the data (part of column G), run a macro, and have it output in the following format to a predetermined cell ie E1

a@a.com;b@b.com;c@c.com

With phone numbers, will need to do the same thing but use a "," instead of ";"

I've tried varients of code I have found but really don't understand VB enough to make them do what I want

Cheers
Paul