New boy help

I have a list of people on a spread sheet this also includes email addresses. However when I want to email these people I have to insert a comma after their address to separate them when I cut and paste into my email provider. There are about a thousand of them. How can I repeat the comma in the spread sheet please so the emails are sepearted when pasted into email 


I was given this formula but it just spreads the emails across the spread sheet.


Let’s assume your all entries are in column A starting in A1.. Put following B1: = A1 B2: = =B1&” , “&A2 Now drag down formula in B2 till last entry, you will have all e mails separated by comma. For individual mails, just put following formula in B1 =A1&”,”

By: Michael Cole

Leave a Reply

Your email address will not be published. Required fields are marked *