Solved

Exporting email column as a Comma Separated Values

Posted on 2014-03-14
4
174 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 14

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:
itjockey earned 500 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 29

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 49

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

785 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