Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List of email addresses
Hi
I have a column with about 40 email addresses one below the other (i cell for each address). I would like to run a macro on the range so that all the addresses are combined in the one cell prefereably in the adjacent column. There is a semicolon at end of each address so I dont have to worry about the data ending up in one cell. Any help appreciated on this. Thanks, Aidan. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List of email addresses
You can do this without a macro:
If addresses start in A1 then in B1 put =A1 In B2 put =B1&A2 Copy the formula in B2 down to the bottom of your data. If you only want the last cell contents, copy it and do paste special, values only. Now delete the other B column entries. I have an excel sheet that takes a range of names and email addresses and converts it into an outlook contacts folder (which you can name). Email me directly if you would like a copy. regards Paul On May 8, 9:18*am, Aidan wrote: Hi I have a column with about 40 email addresses one below the other (i cell for each address). I would like to run a macro on the range so that all the addresses are combined in the one cell prefereably in the adjacent column. There is a semicolon at end of each address so I dont have to worry about the data ending up in one cell. Any help appreciated on this. Thanks, Aidan. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List of email addresses
Thanks Paul.
" wrote: You can do this without a macro: If addresses start in A1 then in B1 put =A1 In B2 put =B1&A2 Copy the formula in B2 down to the bottom of your data. If you only want the last cell contents, copy it and do paste special, values only. Now delete the other B column entries. I have an excel sheet that takes a range of names and email addresses and converts it into an outlook contacts folder (which you can name). Email me directly if you would like a copy. regards Paul On May 8, 9:18 am, Aidan wrote: Hi I have a column with about 40 email addresses one below the other (i cell for each address). I would like to run a macro on the range so that all the addresses are combined in the one cell prefereably in the adjacent column. There is a semicolon at end of each address so I dont have to worry about the data ending up in one cell. Any help appreciated on this. Thanks, Aidan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I merge a list of email addresses from exel into outlook? | New Users to Excel | |||
How do I eliminate bad email addresses from column list? | Excel Discussion (Misc queries) | |||
excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
import email addresses into an excell list | New Users to Excel |