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.