Merge email address list

[ozwebsh]

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

[ragulduy]

There are a few UDF's for doing this sort of thing available. One is below. Then type something like =Range2Csv(G5:G14,";") in E1, where G5:G14 is the cells you want to apply it to and ; is the delimiter you want.

Please Login or Register  to view this content.

[ozwebsh]

Hi ragulduy

That actually makes sense! Thanks

However on using it in my sheet, excel seems to recognise Range2Csv as a function but I get a #NAME? error when I use it in the format you specified (with or without a delimiter)

[ragulduy]

Where have you put the code? It should be in a separate module.

Can you upload your worksheet?

[ozwebsh]

Hi Ragulduy

Seems it musnt have saved properly or something - its all good now!

Works just as I was after - thanks for your help, much appreciated.

Cheers
Paul

[JOHN H. DAVIS]

Assumes the email addresses are in Column F and places them in E1.
Assumes the phone numbers are in Column G and places them in D1.

Please Login or Register  to view this content.