Extracting email addresses from certain cells and placing them all together in one cell.

[dpaton05]

I have information that I am going to copy into a spreadsheet from a webpage. It is a list of email addresses that I want to send emails to. I need it in the format of "xxx@xxx.com, xxx@xxx.com, xxx@xxx.com" for however many addresses are on the list. The addresses are all in column B. There is the person's name in B1, their address in B2 and some other data in B3. This process is then repeated for each email address with the name of the second person being in B4, their address in B5 and the additional data in B6 and so on for the entire list. I need to extract the emails just into a single cell in the format explained above. Could someone help me please?

 

[Herakles]

Select and copy the result of the formula but if you are pasting into another Excel cell, paste as values.

It is easier to see the end of the string if you paste it into a Word document,

 

[dpaton05]

That seems to have worked. I paste it as values and that shows the entire list of emails. Also, if I paste it into a word document, I can see the addresses much easier, thanks.