Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Exporting email column as a Comma Separated Values

Posted on 2014-03-14
4
Medium Priority
?
185 Views
Last Modified: 2014-03-14
Hi Folks,

I have an excel column with email addresses. How do I convert the column into a format like this, so that I can copy and paste into an email.

rg@abc.com, ab@abc.com,tt@abc.com

Thanks

RG
0
Comment
Question by:rgarimella
4 Comments
 
LVL 15

Expert Comment

by:Juan Ocasio
ID: 39929407
You can select the column and then perform a  Text to Columns with a delimiter of comma
0
 
LVL 8

Accepted Solution

by:
Naresh Patel earned 2000 total points
ID: 39929412
Assuming email addresses column is A with header.
Step 1 Formula in cell B2 =A2
Step 2 Formula in cell B3 =B2&","&A3
Step 3 Formula drop down
Done
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39929439
if your addresses are in Col A you can put this in B1
=A1 &","&A2&","&A3&","&A4

for sure you can add to as many rows as you have

if you have plenty then a small VBA can do it

Sub AddEmail()
Dim WS As Worksheet
Dim MaxRow As Long, I As Long

Set WS = ActiveSheet
MaxRow = WS.Range("A" & WS.Rows.Count).End(xlUp).Row

For I = 1 To MaxRow
    If WS.Cells(1, "B") <> "" Then WS.Cells(1, "B") = WS.Cells(1, "B") & ","
    WS.Cells(1, "B") = WS.Cells(1, "B") & WS.Cells(I, "A")
Next I
End Sub

Open in new window


check the file
gowflow
email.xls
0
 
LVL 53

Expert Comment

by:Rgonzo1971
ID: 39929448
Or as an UDF in VBA

Function fJoinEmails(rng As Range) As String
    fJoinEmails = Join(WorksheetFunction.Index(WorksheetFunction.Transpose(rng), 1, 0), ", ")
End Function

Open in new window

Regards
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question